APPS.PV_AS_ACCESS_VHUK dependencies on HZ_RELATIONSHIPS

Line 48: hz_relationships CONTACT,

44: CURSOR lc_get_rel_type(pc_salesforce_id number) is
45: SELECT
46: PTORG.relationship_code
47: FROM
48: hz_relationships CONTACT,
49: hz_relationships PTORG,
50: pv_partner_profiles PVPP,
51: jtf_rs_resource_extns EXTN
52: WHERE EXTN.resource_id = pc_salesforce_id

Line 49: hz_relationships PTORG,

45: SELECT
46: PTORG.relationship_code
47: FROM
48: hz_relationships CONTACT,
49: hz_relationships PTORG,
50: pv_partner_profiles PVPP,
51: jtf_rs_resource_extns EXTN
52: WHERE EXTN.resource_id = pc_salesforce_id
53: AND EXTN.source_id = CONTACT.party_id

Line 87: 1 from as_accesses_all acc , hz_relationships hzpp , hz_parties ptorg,

83:
84: CURSOR lc_get_upd_del_check_perm(pc_lead_id number, pc_access_id number) is
85:
86: SELECT
87: 1 from as_accesses_all acc , hz_relationships hzpp , hz_parties ptorg,
88: fnd_user fndu, jtf_rs_resource_extns jtfre,
89: hz_parties ptorg1 ,hz_relationships hzpp1
90: WHERE
91: acc.partner_cont_party_id = hzpp.party_id and

Line 89: hz_parties ptorg1 ,hz_relationships hzpp1

85:
86: SELECT
87: 1 from as_accesses_all acc , hz_relationships hzpp , hz_parties ptorg,
88: fnd_user fndu, jtf_rs_resource_extns jtfre,
89: hz_parties ptorg1 ,hz_relationships hzpp1
90: WHERE
91: acc.partner_cont_party_id = hzpp.party_id and
92: hzpp.object_id = ptorg.party_id and
93: ptorg.party_type = 'ORGANIZATION' and

Line 109: hz_relationships CONTACT,

105: CURSOR lc_is_partner_user is
106:
107: SELECT 'PARTNER_OF'
108: FROM
109: hz_relationships CONTACT,
110: pv_partner_profiles PVPP,
111: jtf_rs_resource_extns EXTN,
112: fnd_user fndu
113: WHERE fndu.user_id = fnd_global.user_id