APPS.AHL_FLEET_FORECAST_PVT dependencies on AHL_UNIT_EFFECTIVITIES_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:

Line 495: FROM ahl_unit_effectivities_b

491:
492: CURSOR get_sr_mr_headers(c_cs_incident_id NUMBER)
493: IS
494: SELECT mr_header_id, object_version_number
495: FROM ahl_unit_effectivities_b
496: WHERE unit_effectivity_id
497: IN (
498: SELECT related_ue_id
499: FROM ahl_ue_relationships urs, ahl_unit_effectivities_b ueb

Line 499: FROM ahl_ue_relationships urs, ahl_unit_effectivities_b ueb

495: FROM ahl_unit_effectivities_b
496: WHERE unit_effectivity_id
497: IN (
498: SELECT related_ue_id
499: FROM ahl_ue_relationships urs, ahl_unit_effectivities_b ueb
500: WHERE urs.ue_id = ueb.unit_effectivity_id
501: AND ueb.cs_incident_id = c_cs_incident_id
502: );
503: