APPS.PV_MATCH_PARTNER SQL Statements

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

Line: 355

		select INCUMBENT_PARTNER_PARTY_ID
		from as_leads_all
		where lead_id = pc_lead_id;

Line: 463

		select  a.attribute_id , a.sql_text ,  upper(a.src_pkcol_name) src_pkcol_name,  v.short_name
		from   pv_entity_attrs a, pv_attributes_vl v
		where  a.attribute_id = v.attribute_id
		and    a.entity = 'LEAD'
		and    a.enabled_flag= 'Y'
		and    a.auto_assign_flag='Y'
		and    v.enabled_flag='Y'
		order   by a.rank;