DBA Data[Home] [Help]

APPS.OKC_XPRT_REP_INT_PVT dependencies on FND_USER

Line 97: fnd_user fu

93: FROM Hr_all_organization_units
94: WHERE organization_id = orc.org_id) contract_organization,
95: (SELECT nvl(pf.full_name, fu.user_name)
96: FROM Per_all_people_f pf,
97: fnd_user fu
98: WHERE fu.user_id = orc.owner_id
99: AND pf.person_id (+) = fu.employee_id
100: AND (fu.employee_id IS NULL OR pf.effective_start_date = (SELECT MAX(effective_start_date)
101: FROM per_all_people_f