APPS.AHL_PRD_MRSHL_PVT dependencies on WIP_DISCRETE_JOBS

Line 1417: FROM AHL_WORKORDERS WO,WIP_DISCRETE_JOBS WDJ

1413: ) RETURN NUMBER IS
1414:
1415: CURSOR completed_time_csr(p_visit_id NUMBER) IS
1416: SELECT nvl(SUM(WDJ.SCHEDULED_COMPLETION_DATE - WDJ.SCHEDULED_START_DATE),0)
1417: FROM AHL_WORKORDERS WO,WIP_DISCRETE_JOBS WDJ
1418: WHERE WO.visit_id = p_visit_id
1419: AND WO.wip_entity_id = WDJ.wip_entity_id
1420: AND WO.STATUS_CODE IN('4','5','7','12')
1421: GROUP BY WO.visit_id;

Line 1432: FROM AHL_WORKORDERS WO,WIP_DISCRETE_JOBS WDJ

1428: GROUP BY visit_id;
1429:
1430: CURSOR total_time_csr(p_visit_id NUMBER) IS
1431: SELECT nvl(SUM(WDJ.SCHEDULED_COMPLETION_DATE - WDJ.SCHEDULED_START_DATE),0)
1432: FROM AHL_WORKORDERS WO,WIP_DISCRETE_JOBS WDJ
1433: WHERE WO.visit_id = p_visit_id
1434: AND WO.wip_entity_id = WDJ.wip_entity_id
1435: AND wo.STATUS_CODE NOT IN ('22','17')
1436: GROUP BY WO.visit_id;