APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_FLEET_HEADERS_B

Line 1951: FROM ahl_fleet_utlzn_forecast FUF ,ahl_fleet_unit_assocs FUA, ahl_fleet_headers_b FLT

1947: AND trunc(nvl(association_end, sysdate)) >= trunc(sysdate);
1948:
1949: CURSOR ahl_fleet_uf_details_csr(c_uc_header_id IN NUMBER, c_simulation_plan_id In NUMBER) IS
1950: SELECT FUF.uom_code, FUF.period_start_date, FUF.period_end_date,FUA.association_start ,FUA.association_end, FUF.forecasted_daily_usage usage_per_day
1951: FROM ahl_fleet_utlzn_forecast FUF ,ahl_fleet_unit_assocs FUA, ahl_fleet_headers_b FLT
1952: WHERE FUF.fleet_header_id = FUA.fleet_header_id
1953: AND trunc(nvl(period_end_date, sysdate)) >= trunc(sysdate)
1954: AND trunc(nvl(association_end, sysdate)) >= trunc(sysdate)
1955: AND trunc(nvl(period_end_date, association_start)) >= trunc(association_start)

Line 3686: FROM ahl_fleet_unit_assocs FUA, ahl_fleet_headers_b FLT

3682: CURSOR get_next_fleet_asso_date(l_date DATE)
3683: IS
3684: SELECT * FROM(
3685: SELECT FUA.association_start
3686: FROM ahl_fleet_unit_assocs FUA, ahl_fleet_headers_b FLT
3687: WHERE FUA.unit_config_header_id = G_UC_HEADER_ID
3688: AND FUA.simulation_plan_id = nvl(G_SIMULATION_PLAN_ID, get_primary_plan_id)
3689: AND FLT.fleet_header_id = FUA.fleet_header_id
3690: AND FLT.status_code = 'COMPLETE'

Line 16096: FROM ahl_fleet_unit_assocs FUA, ahl_fleet_headers_b FLT

16092: CURSOR date_withing_flt_asso(c_unit_config_header_id NUMBER,
16093: c_due_date DATE,
16094: c_plan_id NUMBER) IS
16095: SELECT FUA.fleet_header_id
16096: FROM ahl_fleet_unit_assocs FUA, ahl_fleet_headers_b FLT
16097: WHERE unit_config_header_id = c_unit_config_header_id
16098: AND c_due_date between ASSOCIATION_START and nvl(ASSOCIATION_END,c_due_date)
16099: AND FLT.fleet_header_id = FUA.fleet_header_id
16100: AND FLT.status_code = 'COMPLETE'