APPS.PV_BATCH_ASSIGN_PUB dependencies on HZ_LOCATIONS

Line 98: hz_locations e, as_statuses_b f

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
102: AND d.status IN ('A','I')