DBA Data[Home] [Help]

APPS.AHL_UMP_UTIL_PKG dependencies on AHL_FLEET_HEADERS_B

Line 1597: FROM ahl_fleet_unit_assocs FUA, ahl_fleet_headers_b FLT

1593: c_due_date DATE,
1594: c_plan_id NUMBER)
1595: IS
1596: SELECT FUA.fleet_header_id
1597: FROM ahl_fleet_unit_assocs FUA, ahl_fleet_headers_b FLT
1598: WHERE unit_config_header_id = c_unit_config_header_id
1599: AND c_due_date between ASSOCIATION_START and nvl(ASSOCIATION_END,c_due_date)
1600: AND FLT.fleet_header_id = FUA.fleet_header_id
1601: AND FLT.status_code = 'COMPLETE'