Unable to INSERT rec into Table.

I am using the ADF . Execute Pipeline activity.
My PL is parametrized.

My stage table have the below rec:

WITH CodeSourceTableCTE AS
	(
	SELECT DISTINCT p.[partner_number]
		  ,n.[network_org_number]
	FROM [utl].[stg_partner_network_org] stg
	LEFT JOIN [utl].[partner] p1
	ON stg.[parent_partner_name] = p1.[partner_name]
	INNER JOIN [utl].[partner] p
	ON stg.[partner_name] = p.[partner_name] AND ISNULL(p.[delete_ind], '') <> 'Y' 
    AND ISNULL(p.[parent_partner_number], '') = ISNULL(p1.[partner_number], '') AND ISNULL(p1.[delete_ind], '') <> 'Y' 
	AND ISNULL(stg.[corpart_number], '') = ISNULL(p.[external_id], '')
	INNER JOIN [utl].[network_org] n
	ON stg.[network_org_name] = n.[network_org_name]
	WHERE stg.[partner_name] IS NOT NULL
	)
			
	MERGE [utl].[partner_network_org] T
	USING CodeSourceTableCTE S 
	   ON T.[partner_number] = S.[partner_number]
	  AND T.[network_org_number] = S.[network_org_number]

	  WHEN MATCHED AND (ISNULL(T.[delete_ind], '') <> 'N') THEN
		  UPDATE 
			 SET T.[delete_ind] = 'N',
				 T.[last_modified_date] = GETUTCDATE(),
				 T.[last_modified_by] = '@{pipeline().parameters.Source_File_Name}'
			
	 WHEN NOT MATCHED BY TARGET THEN
		  INSERT ([partner_number], [network_org_number], [created_date], [created_by], [last_modified_date], [last_modified_by], [delete_ind])
		  VALUES (S.[partner_number], S.[network_org_number], GETUTCDATE(), '@{pipeline().parameters.Source_File_Name}', GETUTCDATE(), '@{pipeline().parameters.Source_File_Name}', 'N');

SELECT COUNT(*) FROM [utl].[partner_network_org] WHERE [created_by] = '@{pipeline().parameters.Source_File_Name}'

But when I am trying to check using below 

select * from utl.partner_network_org
where partner_number in (select partner_number  from utl.partner where last_modified_by like '%corpart%')

I don't see records any help is appreciated