APPS.PV_BENFT_STATUS_CHANGE dependencies on AS_LEADS_ALL

Line 461: select lead_number, prm_referral_code from as_leads_all where lead_id = pc_lead_id;

457: from pv_referrals_b ref, pv_ge_benefits_b ben
458: where ref.referral_id = pc_entity_id and ref.benefit_id = ben.benefit_id;
459:
460: cursor lc_oppty_linked_flag (pc_lead_id number) is
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;