APPS.PV_AS_ACCESS_VHUK dependencies on JTF_RS_RESOURCE_EXTNS

Line 51: jtf_rs_resource_extns EXTN

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
54: AND EXTN.category = 'PARTY'
55: AND CONTACT.subject_table_name = 'HZ_PARTIES'

Line 88: fnd_user fndu, jtf_rs_resource_extns jtfre,

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
92: hzpp.object_id = ptorg.party_id and

Line 111: jtf_rs_resource_extns EXTN,

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
114: AND EXTN.user_id = fndu.user_id
115: AND CONTACT.party_id = EXTN.source_id