DBA Data[Home] [Help]

APPS.OKC_XPRT_REP_INT_PVT dependencies on PER_ALL_PEOPLE_F

Line 96: FROM Per_all_people_f pf,

92: (SELECT name
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)

Line 101: FROM per_all_people_f

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
102: WHERE person_id = fu.employee_id))) contract_owner,
103: obd.name contract_type_name,
104: fl1.meaning intent,
105: (SELECT meaning