DBA Data[Home] [Help]

APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on HZ_RELATIONSHIPS

Line 266: hz_relationships rel_ship,

262: vendor.party_name VENDOR_NAME,
263: partner.party_id PARTNER_ID,
264: partner.party_name PARTNER_NAME
265: FROM pv_partner_profiles prtnr_profile,
266: hz_relationships rel_ship,
267: hz_parties partner,
268: hz_parties vendor
269: WHERE prtnr_profile.partner_id =cv_partner_id
270: AND prtnr_profile.partner_id = rel_ship.party_id

Line 331: hz_relationships rel_ship,

327: partner.party_id PARTNER_ID,
328: partner.party_name PARTNER_NAME
329: FROM pv_pg_enrl_requests enrl_req,
330: pv_partner_profiles prtnr_profile,
331: hz_relationships rel_ship,
332: hz_parties partner,
333: hz_parties vendor
334: WHERE enrl_req.enrl_request_id = cv_enrl_request_id
335: AND enrl_req.partner_id= prtnr_profile.partner_id