APPS.AHL_FLEET_FORECAST_PVT dependencies on AHL_MR_HEADERS_B

Line 49: FROM AHL_MR_EFFECTIVITIES mef, AHL_MR_HEADERS_B mhb

45: AND fhb.status_code = 'DRAFT'
46: AND fhb.completion_date IS NULL
47: AND NOT EXISTS
48: (SELECT 1
49: FROM AHL_MR_EFFECTIVITIES mef, AHL_MR_HEADERS_B mhb
50: WHERE fhb.fleet_header_id = mef.fleet_header_id
51: AND mhb.mr_header_id = mef.mr_header_id
52: AND mhb.mr_status_code NOT IN ('DRAFT')
53: );

Line 62: FROM AHL_MR_EFFECTIVITIES mef, AHL_MR_HEADERS_B mhb

58: FROM AHL_FLEET_HEADERS_B fhb
59: WHERE fhb.fleet_header_id = p_fleet_id
60: AND EXISTS
61: (SELECT 1
62: FROM AHL_MR_EFFECTIVITIES mef, AHL_MR_HEADERS_B mhb
63: WHERE fhb.fleet_header_id = mef.fleet_header_id
64: AND mhb.mr_header_id = mef.mr_header_id
65: AND mhb.mr_status_code = 'COMPLETE'
66: );