APPS.PV_BATCH_ASSIGN_PUB dependencies on HZ_PARTY_SITES

Line 97: pv_channel_types c,hz_party_sites d,

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
101: AND d.location_id = e.location_id