APPS.EAM_SAFETY_REPORTS_PVT dependencies on PER_PEOPLE_F

Line 69: per_people_f ppf

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
73: and EWP.created_by = fu.user_id(+)

Line 88: per_people_f ppf ,

84: XMLFOREST(
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(+)