DBA Data[Home] [Help]

APPS.EAM_SAFETY_REPORTS_PVT dependencies on FND_USER

Line 68: fnd_user fu,

64: ))"PERMIT_HEADER"
65: FROM EAM_WORK_PERMITS EWP,
66: EAM_PERMIT_STATUSES_VL EPSV,
67: mfg_lookups ml,
68: fnd_user fu,
69: per_people_f ppf
70: WHERE EWP.PERMIT_ID =P_PERMIT_ID
71: AND EWP.ORGANIZATION_ID =P_ORGANIZATION_ID
72: AND EPSV.STATUS_ID =EWP.USER_DEFINED_STATUS_ID

Line 89: fnd_user fu

85: ppf.full_name AS APPROVER_NAME)) "APPROVER"
86: FROM
87: EAM_WORK_PERMITS EWP,
88: per_people_f ppf ,
89: fnd_user fu
90: WHERE EWP.PERMIT_ID =P_PERMIT_ID
91: AND EWP.ORGANIZATION_ID =P_ORGANIZATION_ID
92: AND EWP.approved_by = fu.user_id(+)
93: and fu.employee_id = ppf.person_id (+)