DBA Data[Home] [Help]

APPS.PV_AS_ACCESS_VHUK dependencies on FND_GLOBAL

Line 96: fndu.user_id = fnd_global.user_id and

92: hzpp.object_id = ptorg.party_id and
93: ptorg.party_type = 'ORGANIZATION' and
94: --acc.salesforce_id = pc_sales_force_id and
95: acc.access_id = pc_access_id and
96: fndu.user_id = fnd_global.user_id and
97: jtfre.user_id = fndu.user_id and
98: jtfre.source_id = hzpp1.party_id and
99: hzpp1.object_id = ptorg1.party_id and
100: ptorg1.party_type = 'ORGANIZATION' and

Line 113: WHERE fndu.user_id = fnd_global.user_id

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'
117: AND CONTACT.object_table_name = 'HZ_PARTIES'