DBA Data[Home] [Help]

APPS.EAM_SAFETY_REPORTS_PVT dependencies on EAM_PERMIT_STATUSES_VL

Line 66: EAM_PERMIT_STATUSES_VL EPSV,

62: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_FROM), calendar_aware => FND_DATE.calendar_aware_alt) AS PERMIT_VALID_FROM,
63: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS PERMIT_VALID_TO
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

Line 434: EAM_PERMIT_STATUSES_VL EPSV

430: EWP.APPROVED_BY AS approverName),
431: XMLConcat(l_xmlTypeAssociatedClearance,l_xmlTypeAssociatedWO,l_xmlTypefileattachment)))AS "RESULT"
432: INTO l_xmlType
433: FROM EAM_WORK_PERMITS EWP,
434: EAM_PERMIT_STATUSES_VL EPSV
435: WHERE EWP.PERMIT_ID =p_permit_ids(i).permit_id
436: AND EWP.ORGANIZATION_ID =l_organization_id
437: AND EPSV.STATUS_ID =EWP.USER_DEFINED_STATUS_ID;*/
438: