APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 1386: FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK, AHL_UNIT_EFFECTIVITIES_B UE

1382:
1383: -- Added by jaramana on October 8, 2007 for ER 5903256
1384: CURSOR check_nr_wo_status_csr(p_nr_workorder_id IN NUMBER) IS
1385: SELECT 'Y'
1386: FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK, AHL_UNIT_EFFECTIVITIES_B UE
1387: WHERE WO.workorder_id = NVL(p_nr_workorder_id, -1)
1388: AND TSK.VISIT_TASK_ID = WO.VISIT_TASK_ID
1389: AND UE.UNIT_EFFECTIVITY_ID = TSK.UNIT_EFFECTIVITY_ID
1390: AND UE.STATUS_CODE IS NULL;