APPS.PV_LOCATOR dependencies on PV_PARTNER_PROFILES

Line 131: pv_partner_profiles pvpp

127: hz_parties org,
128: hz_party_sites hzs,
129: hz_locations hzl,
130: hz_contact_points cp,
131: pv_partner_profiles pvpp
132: where tmp.party_id = pvpp.partner_id
133: and org.party_id = pvpp.partner_party_id
134: and org.party_type = 'ORGANIZATION'
135: and org.party_id = cp.owner_table_id (+)

Line 718: ' pv_partner_profiles pvpp, '||

714: ' rownum rn '||
715: ' from hz_parties org, ' ||
716: ' hz_party_sites hzs, ' ||
717: ' hz_locations hzl, '||
718: ' pv_partner_profiles pvpp, '||
719: ' (SELECT * ' ||
720: ' FROM (SELECT column_value party_id ' ||
721: ' FROM (SELECT column_value ' ||
722: ' FROM TABLE (CAST(:p_partner_tbl AS JTF_NUMBER_TABLE))))) c ' ||

Line 776: pv_partner_profiles pvpp,

772: hzl.postal_code, rownum rn
773: FROM hz_parties org,
774: hz_party_sites hzs,
775: hz_locations hzl,
776: pv_partner_profiles pvpp,
777: (SELECT *
778: FROM (SELECT column_value party_id
779: FROM (SELECT column_value
780: FROM TABLE(CAST(:p_partner_tbl AS JTF_NUMBER_TABLE))))) c