DBA Data[Home] [Help]

APPS.AHL_FLEET_FORECAST_PVT dependencies on AHL_VISIT_TASKS_B

Line 481: FROM ahl_visit_tasks_b vt, ahl_unit_effectivities_b ue

477:
478: CURSOR is_sr_planned(c_cs_incident_id NUMBER)
479: IS
480: SELECT 'X'
481: FROM ahl_visit_tasks_b vt, ahl_unit_effectivities_b ue
482: WHERE vt.status_code <> 'DELETED'
483: AND vt.unit_effectivity_id = ue.unit_effectivity_id
484: AND ue.cs_incident_id = c_cs_incident_id;
485: