APPS.AML_LEAD_DEDUPE_PVT dependencies on AS_SALES_LEADS

Line 316: l_from_clause := 'FROM as_sales_leads asleads ';

312:
313: -- First form mendatory select clause
314: l_sql_string := 'SELECT sales_lead_id ';
315:
316: l_from_clause := 'FROM as_sales_leads asleads ';
317:
318: l_where_clause := ' WHERE asleads.customer_id = :party_id ';
319: l_where_clause := l_where_clause ||' AND asleads.creation_date > trunc(sysdate - :l_created_within_days ) ';
320:

Line 558: l_sales_lead_id as_sales_leads.sales_lead_id%TYPE;

554: l_duplicate_flag VARCHAR2 (1) := 'U';
555: l_contact_id hz_parties.party_id%TYPE;
556: l_party_id hz_parties.party_id%TYPE;
557: l_party_site_id hz_party_sites.party_site_id%TYPE;
558: l_sales_lead_id as_sales_leads.sales_lead_id%TYPE;
559:
560: BEGIN
561: SAVEPOINT MAIN_PVT;
562: