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_MATCH_V2_PUB dependencies on AS_LEADS_ALL

Line 80: from as_leads_all asla

76:
77:
78: cursor lc_get_incumbent_pt (pc_lead_id number) is
79: select asla.INCUMBENT_PARTNER_PARTY_ID
80: from as_leads_all asla
81: where asla.lead_id = pc_lead_id;
82:
83:
84: l_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 216: FROM as_leads_all a,

212: END IF;
213: BEGIN
214: SELECT b.location_id
215: INTO l_customer_address.location_id
216: FROM as_leads_all a,
217: hz_party_sites b,
218: hz_locations l
219: WHERE a.lead_id = p_lead_id AND
220: a.customer_id = b.party_id AND

Line 2093: from as_leads_all asla

2089: l_incumbent_party_name VARCHAR2(3600);
2090:
2091: cursor lc_get_incumbent_pt (pc_lead_id number) is
2092: select asla.INCUMBENT_PARTNER_PARTY_ID
2093: from as_leads_all asla
2094: where asla.lead_id = pc_lead_id;
2095:
2096:
2097: cursor lc_get_flag_count(pc_lead_id number , pc_partner_id number ,