DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_OPP_PVT dependencies on PV_PARTNERS_V

Line 2451: FROM PV_PARTNERS_V pv,

2447: -- Start Bug#3966128
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