APPS.PV_PARTNER_UTIL_PVT dependencies on PV_PARTNER_PROFILES

Line 253: pv_partner_profiles pvpp

249: from (
250: SELECT distinct 4 attribute_id, hl.country attr_text, pvpp.partner_id partner_id
251: FROM hz_locations hl,
252: hz_party_sites hs,
253: pv_partner_profiles pvpp
254: WHERE hl.location_id = hs.location_id
255: AND hs.party_id = pvpp.partner_party_id
256: AND pvpp.partner_id = :1
257: AND (hs.status = ''A'' OR hs.status IS NULL)

Line 266: pv_partner_profiles PVPP

262: hz_parties PARTNER,
263: hz_organization_profiles HZOP,
264: hz_parties INTERNAL,
265: hz_relationships HZR,
266: pv_partner_profiles PVPP
267: WHERE HZR.party_id = PVPP.partner_id
268: AND HZR.object_id = INTERNAL.party_id
269: AND HZR.subject_id = PVPP.partner_party_id
270: AND HZR.subject_id = PARTNER.party_id

Line 626: pv_partner_profiles pvpp

622: from (
623: SELECT distinct 4 attribute_id, hl.country attr_text, pvpp.partner_id partner_id
624: FROM hz_locations hl,
625: hz_party_sites hs,
626: pv_partner_profiles pvpp
627: WHERE hl.location_id = hs.location_id
628: AND hs.party_id = pvpp.partner_party_id
629: AND pvpp.partner_id = :1
630: AND (hs.status = ''A'' OR hs.status IS NULL)

Line 639: pv_partner_profiles PVPP

635: hz_parties PARTNER,
636: hz_organization_profiles HZOP,
637: hz_parties INTERNAL,
638: hz_relationships HZR,
639: pv_partner_profiles PVPP
640: WHERE HZR.party_id = PVPP.partner_id
641: AND HZR.object_id = INTERNAL.party_id
642: AND HZR.subject_id = PVPP.partner_party_id
643: AND HZR.subject_id = PARTNER.party_id

Line 1878: FROM pv_partner_profiles

1874:
1875: -- Cursor l_partner_csr to get partner details
1876: CURSOR l_partner_csr (cv_party_id NUMBER) IS
1877: SELECT partner_id
1878: FROM pv_partner_profiles
1879: WHERE partner_party_id = cv_party_id;
1880:
1881:
1882: -- Details of local variables used in Create_Partner API call.