APPS.EAM_WORKORDERREP_PVT dependencies on EAM_JOB_COMPLETION_TXNS

Line 1164: FROM EAM_JOB_COMPLETION_TXNS

1160: begin
1161: SELECT XMLConcat(XMLFOREST(fnd_date.date_to_displayDT(dateval => Convert_to_client_time(ACTUAL_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "ACTUALSTARTDATE",
1162: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(ACTUAL_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "ACTUALENDDATE",
1163: round((ACTUAL_END_DATE-ACTUAL_START_DATE)*24,2) as "ACTUALDURATION"),l_xmlTemp3) into l_xmlTemp3
1164: FROM EAM_JOB_COMPLETION_TXNS
1165: WHERE TRANSACTION_TYPE=1
1166: AND TRANSACTION_ID=
1167: (
1168: SELECT MAX(TRANSACTION_ID)

Line 1169: FROM EAM_JOB_COMPLETION_TXNS EJT,WIP_DISCRETE_JOBS WDJ

1165: WHERE TRANSACTION_TYPE=1
1166: AND TRANSACTION_ID=
1167: (
1168: SELECT MAX(TRANSACTION_ID)
1169: FROM EAM_JOB_COMPLETION_TXNS EJT,WIP_DISCRETE_JOBS WDJ
1170: WHERE EJT.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
1171: AND EJT.ORGANIZATION_ID=WDJ.ORGANIZATION_ID
1172: AND WDJ.WIP_ENTITY_ID=p_wip_entity_id(i)
1173: );