APPS.AS_SALES_LEAD_OPP_PVT dependencies on HZ_PARTY_SITES

Line 2452: hz_party_sites hz

2448:
2449: CURSOR c_address_id(x_partner_party_id NUMBER) is
2450: SELECT hz.party_site_id
2451: FROM PV_PARTNERS_V pv,
2452: hz_party_sites hz
2453: WHERE pv.partner_id = x_partner_party_id
2454: AND hz.party_id =pv.partner_party_id
2455: AND pv.PARTNER_PARTY_NAME IS NOT NULL
2456: AND pv.INTERNAL_FLAG||'' = 'Y'