eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_REFERRAL_GENERAL_PUB dependencies on AS_SALES_LEADS

Line 144: as_sales_leads LEAD

140:
141: CURSOR c_closed_dead_lead IS
142: SELECT REF.referral_id, REF.referral_name, REF.benefit_id, REF.partner_id
143: FROM pv_referrals_vl REF,
144: as_sales_leads LEAD
145: WHERE REF.referral_status = 'APPROVED' AND
146: REF.entity_type = 'SALES_LEAD' AND
147: REF.entity_id_linked_to = LEAD.sales_lead_id AND
148: LEAD.status_code = 'DEAD_LEAD';

Line 846: r_lead_header_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;

842: l_line_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
843: l_line_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
844: l_contact_tbl AS_OPPORTUNITY_PUB.Contact_Tbl_Type;
845: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
846: r_lead_header_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;
847: l_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
848: l_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
849: l_lead_line_out_tbl AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type;
850: l_lead_contact_out_tbl AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type;

Line 847: l_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;

843: l_line_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
844: l_contact_tbl AS_OPPORTUNITY_PUB.Contact_Tbl_Type;
845: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
846: r_lead_header_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;
847: l_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
848: l_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
849: l_lead_line_out_tbl AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type;
850: l_lead_contact_out_tbl AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type;
851: l_lead_note_id NUMBER;

Line 848: l_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;

844: l_contact_tbl AS_OPPORTUNITY_PUB.Contact_Tbl_Type;
845: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
846: r_lead_header_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;
847: l_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
848: l_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
849: l_lead_line_out_tbl AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type;
850: l_lead_contact_out_tbl AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type;
851: l_lead_note_id NUMBER;
852:

Line 849: l_lead_line_out_tbl AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type;

845: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
846: r_lead_header_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;
847: l_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
848: l_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
849: l_lead_line_out_tbl AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type;
850: l_lead_contact_out_tbl AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type;
851: l_lead_note_id NUMBER;
852:
853: l_customer_party_id NUMBER;

Line 850: l_lead_contact_out_tbl AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type;

846: r_lead_header_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;
847: l_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
848: l_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
849: l_lead_line_out_tbl AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type;
850: l_lead_contact_out_tbl AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type;
851: l_lead_note_id NUMBER;
852:
853: l_customer_party_id NUMBER;
854: l_customer_party_site_id NUMBER;

Line 2017: FROM as_sales_leads

2013: -- Is this lead already linked to another referral?
2014: -- ----------------------------------------------------------------------
2015: CURSOR c_lead(pc_entity_id NUMBER) IS
2016: SELECT source_system, source_primary_reference
2017: FROM as_sales_leads
2018: WHERE sales_lead_id = pc_entity_id;
2019:
2020: CURSOR c_benefit_type IS
2021: SELECT a.benefit_type_code, b.referral_id, b.partner_id

Line 2176: UPDATE as_sales_leads

2172: -- Link the lead to the referral only if it's not already linked
2173: -- to another referral.
2174: -- --------------------------------------------------------------------
2175: IF (l_count = 0) THEN
2176: UPDATE as_sales_leads
2177: SET source_primary_reference = l_referral_code,
2178: source_system = 'REFERRAL'
2179: WHERE sales_lead_id = p_entity_id;
2180: END IF;