APPS.EAM_WORKORDERREP_PVT dependencies on EAM_JOB_COMPLETION_TXNS

Line 911: FROM EAM_JOB_COMPLETION_TXNS

907: --Adding Actual Start Date and Actual End Date
908: begin
909: SELECT XMLConcat(XMLFOREST(fnd_date.date_to_displayDT(Convert_to_client_time(ACTUAL_START_DATE)) as "ACTUALSTARTDATE", fnd_date.date_to_displayDT(Convert_to_client_time(ACTUAL_END_DATE)) as "ACTUALENDDATE",
910: round((ACTUAL_END_DATE-ACTUAL_START_DATE)*24,2) as "ACTUALDURATION"),l_xmlTemp3) into l_xmlTemp3
911: FROM EAM_JOB_COMPLETION_TXNS
912: WHERE TRANSACTION_TYPE=1
913: AND TRANSACTION_ID=
914: (
915: SELECT MAX(TRANSACTION_ID)

Line 916: FROM EAM_JOB_COMPLETION_TXNS EJT,WIP_DISCRETE_JOBS WDJ

912: WHERE TRANSACTION_TYPE=1
913: AND TRANSACTION_ID=
914: (
915: SELECT MAX(TRANSACTION_ID)
916: FROM EAM_JOB_COMPLETION_TXNS EJT,WIP_DISCRETE_JOBS WDJ
917: WHERE EJT.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
918: AND EJT.ORGANIZATION_ID=WDJ.ORGANIZATION_ID
919: AND WDJ.WIP_ENTITY_ID=p_wip_entity_id(i)
920: );