APPS.CAC_SYNC_CONTACT_DQM_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

        SELECT user_profile_option_name
          FROM fnd_profile_options_vl
         WHERE profile_option_name = p_profile_option_name;

Line: 29

        SELECT party_id
          FROM hz_matched_parties_gt
         WHERE search_context_id = p_search_ctx_id;

Line: 228

		SELECT REL.PARTY_ID
		  FROM HZ_RELATIONSHIPS REL
		     , HZ_ORG_CONTACTS ORCT
		     , HZ_MATCHED_CONTACTS_GT GT
		 WHERE REL.RELATIONSHIP_ID = ORCT.PARTY_RELATIONSHIP_ID
		   AND REL.DIRECTIONAL_FLAG = 'F'
		   AND ORCT.ORG_CONTACT_ID = GT.ORG_CONTACT_ID
		   AND GT.SEARCH_CONTEXT_ID = b_search_context_id;