APPS.AHL_PRD_DF_PVT dependencies on AHL_WORKORDER_TASKS_V

Line 896: SELECT 'x' from ahl_workorder_tasks_v WO,AHL_UNIT_EFFECTIVITIES_B UE --Undid App usage related BLIND changes

892: AND unit_effectivity_id = p_unit_effectivity_id;
893:
894: -- to check whether ue is in production
895: CURSOR valid_deferral_csr(p_unit_effectivity_id IN NUMBER) IS
896: SELECT 'x' from ahl_workorder_tasks_v WO,AHL_UNIT_EFFECTIVITIES_B UE --Undid App usage related BLIND changes
897: WHERE WO.unit_effectivity_id = UE.unit_effectivity_id
898: AND NVL(UE.status_code,'x') NOT IN('ACCOMPLISHED','DEFERRED','EXCEPTION','TERMINATED','CANCELLED','MR-TERMINATE')
899: AND UE.unit_effectivity_id = p_unit_effectivity_id;
900:

Line 3862: FROM ahl_workorder_tasks_v WO

3858: CURSOR validate_approver_privilages(p_unit_effectivity_id IN NUMBER)IS
3859:
3860: /* replaced as this query does not pick up master workorders.
3861: SELECT WO.workorder_id
3862: FROM ahl_workorder_tasks_v WO
3863: WHERE WO.job_status_code NOT IN ( G_JOB_DRAFT,G_JOB_DELETED)
3864: AND WO.unit_effectivity_id = p_unit_effectivity_id; */
3865:
3866: SELECT WO.workorder_id

Line 5916: FROM ahl_workorder_tasks_v wo, ahl_unit_deferrals_b udf

5912: IS
5913: CURSOR wo_exists_csr(p_unit_deferral_id IN NUMBER) IS
5914: /* -- fix for bug# 6849943 (FP for Bug # 6815689).
5915: SELECT 'x'
5916: FROM ahl_workorder_tasks_v wo, ahl_unit_deferrals_b udf
5917: WHERE wo.unit_effectivity_id = udf.unit_effectivity_id
5918: AND udf.unit_deferral_id = p_unit_deferral_id;
5919: */
5920: