DBA Data[Home] [Help]

APPS.PV_AS_ACCESS_VHUK dependencies on FND_USER

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 112: fnd_user fndu

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
116: AND CONTACT.subject_table_name = 'HZ_PARTIES'