APPS.PV_BENFT_STATUS_CHANGE dependencies on AS_SALES_LEADS

Line 465: from as_sales_leads where sales_lead_id = pc_lead_id;

461: select lead_number, prm_referral_code from as_leads_all where lead_id = pc_lead_id;
462:
463: cursor lc_lead_linked_flag (pc_lead_id number) is
464: select lead_number, decode(source_system,'REFERRAL',source_primary_reference,NULL)
465: from as_sales_leads where sales_lead_id = pc_lead_id;
466:
467: cursor lc_ref_linked_flag (pc_referral_id number) is
468: select referral_code from pv_referrals_b where referral_id = pc_referral_id;
469:

Line 1531: from as_sales_leads a, pv_referrals_b b, jtf_rs_resource_extns c

1527: and ref.referral_id = pc_entity_id;
1528:
1529: cursor lc_get_lead_owner (pc_entity_id number) is
1530: select c.user_name
1531: from as_sales_leads a, pv_referrals_b b, jtf_rs_resource_extns c
1532: where b.referral_id = pc_entity_id
1533: and b.entity_id_linked_to = a.sales_lead_id
1534: and a.assign_to_salesforce_id = c.resource_id;
1535: