APPS.PV_ASSIGN_UTIL_PVT dependencies on HZ_RELATIONSHIPS

Line 1064: hz_relationships b,

1060: select distinct
1061: c.resource_id
1062: from
1063: pv_partner_profiles a,
1064: hz_relationships b,
1065: jtf_rs_resource_extns c,
1066: as_accesses_all d,
1067: fnd_user usr
1068: where

Line 1092: hz_relationships pr2,

1088: SELECT
1089: pj.resource_id
1090: FROM
1091: pv_partner_profiles prof,
1092: hz_relationships pr2,
1093: jtf_rs_resource_extns pj,
1094: fnd_user usr
1095: WHERE
1096: prof.partner_id = pc_partner_id

Line 1133: hz_relationships pr,

1129: pr.relationship_code,
1130: pr.object_id,
1131: imp.indirectly_managed_flag
1132: from pv_partner_profiles pf,
1133: hz_relationships pr,
1134: hz_organization_profiles op,
1135: ar_lookups ar,
1136: hz_parties pt,
1137: (select distinct a.partner_id, 'Y' indirectly_managed_flag from pv_partner_accesses a, pv_partner_profiles b

Line 1164: hz_relationships emp,

1160: FROM
1161: pv_partner_accesses PT_ACC,
1162: pv_partner_profiles PT_PROF,
1163: jtf_rs_resource_extns extn,
1164: hz_relationships emp,
1165: jtf_rs_role_relations rel,
1166: jtf_rs_roles_b role
1167: where
1168: PT_ACC.partner_id = pc_partner_id and

Line 1786: FROM hz_parties PARTNER, hz_relationships HZR_PART_CONT, hz_org_contacts ORG_CONTACT,

1782: pc_salesforce_id number
1783: ) is
1784:
1785: SELECT pvpp.partner_id
1786: FROM hz_parties PARTNER, hz_relationships HZR_PART_CONT, hz_org_contacts ORG_CONTACT,
1787: hz_contact_points hcp, pv_partner_profiles pvpp, jtf_rs_resource_extns res
1788: WHERE
1789: PARTNER.PARTY_ID = pvpp.partner_party_id and
1790: PARTNER.party_type = 'ORGANIZATION' AND