APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on HZ_PARTIES

Line 267: hz_parties partner,

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
271: AND prtnr_profile.partner_party_id = rel_ship.object_id

Line 268: hz_parties vendor

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
271: AND prtnr_profile.partner_party_id = rel_ship.object_id
272: AND rel_ship.party_id = cv_partner_id

Line 332: hz_parties partner,

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
336: AND prtnr_profile.partner_id = rel_ship.party_id

Line 333: hz_parties vendor

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
336: AND prtnr_profile.partner_id = rel_ship.party_id
337: AND prtnr_profile.partner_party_id = rel_ship.object_id

Line 4232: FROM hz_parties party

4228: AND mmbr_future.membership_status_code = 'FUTURE';
4229:
4230: CURSOR c_getptrprgm(memb_id NUMBER) IS
4231: SELECT distinct party.party_name, prgm.program_name
4232: FROM hz_parties party
4233: , pv_partner_profiles prof
4234: , pv_pg_memberships memb
4235: , pv_partner_program_vl prgm
4236: WHERE prof.status = 'A'