DBA Data[Home] [Help]

APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on PV_PARTNER_PROFILES

Line 265: FROM pv_partner_profiles prtnr_profile,

261: SELECT vendor.party_id VENDOR_ID,
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

Line 330: pv_partner_profiles prtnr_profile,

326: vendor.party_name VENDOR_NAME,
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

Line 4233: , pv_partner_profiles prof

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'
4237: AND prof.partner_party_id = party.party_id