APPS.EAM_SAFETY_REPORTS_PVT dependencies on EAM_WORK_PERMITS

Line 65: FROM EAM_WORK_PERMITS EWP,

61: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.CREATION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS PREPARED_DATE,
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

Line 87: EAM_WORK_PERMITS EWP,

83: SELECT XMLELEMENT("APPROVER",
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

Line 143: EAM_WORK_PERMITS PERMIT,

139: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_ESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_ESTAB_START_DATE,
140: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWC.SCHEDULED_REESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS SCHEDULED_REESTAB_END_DATE
141: FROM
142: EAM_WORK_CLEARANCES EWC,
143: EAM_WORK_PERMITS PERMIT,
144: EAM_SAFETY_ASSOCIATIONS ESA1,
145: EAM_SAFETY_ASSOCIATIONS ESA2,
146: MFG_LOOKUPS ML,
147: EAM_ISOLATIONS ISO,

Line 214: EAM_WORK_PERMITS PERMIT,

210:
211: FROM
212: EAM_SAFETY_ASSOCIATIONS ESA1,
213: EAM_SAFETY_ASSOCIATIONS ESA2,
214: EAM_WORK_PERMITS PERMIT,
215: EAM_WORK_CLEARANCES EWC,
216: EAM_WORK_ORDERS_V WEDV
217:
218: WHERE

Line 289: from EAM_WORK_PERMITS ewp

285: LOOP
286: -- Get org id
287:
288: select ewp.organization_id into l_organization_id
289: from EAM_WORK_PERMITS ewp
290: where ewp.permit_id=p_permit_ids(i).permit_id;
291:
292: l_xmlTypeParamList := xmltype('
293: ' ||Nvl(p_work_clearance_flag,0)|| '

Line 433: FROM EAM_WORK_PERMITS EWP,

429: fnd_date.date_to_displayDT(Convert_to_client_time(EWP.VALID_TO)) AS PERMIT_VALID_TO,
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;*/