APPS.PV_BATCH_ASSIGN_PUB dependencies on AS_LEADS_ALL

Line 75: FROM as_leads_all a,

71:
72: CURSOR lc_vendor (pc_oppty_timeout NUMBER,
73: pc_fromdate DATE) IS
74: SELECT a.lead_id, a.description
75: FROM as_leads_all a,
76: pv_lead_workflows b,
77: pv_channel_types c,
78: as_statuses_b d
79: WHERE a.channel_code = c.channel_lookup_code

Line 96: FROM as_leads_all a, pv_lead_workflows b,

92: CURSOR lc_vendor_cntry(pc_oppty_timeout NUMBER,
93: pc_country VARCHAR2,
94: pc_fromdate DATE) IS
95: SELECT a.lead_id, a.description
96: FROM as_leads_all a, pv_lead_workflows b,
97: pv_channel_types c,hz_party_sites d,
98: hz_locations e, as_statuses_b f
99: WHERE a.channel_code = c.channel_lookup_code
100: AND a.address_id = d.party_site_id