APPS.AHL_FLEET_FORECAST_PVT dependencies on AHL_FLEET_RECONFIG_MRS

Line 215: FROM AHL_FLEET_RECONFIG_MRS

211: FROM AHL_FLEET_UTILIZATION
212: WHERE fleet_header_id = p_fleet_id;
213: -- Reconfig MRs
214: DELETE
215: FROM AHL_FLEET_RECONFIG_MRS
216: WHERE fleet_header_id = p_fleet_id;
217: IF (l_log_statement >= l_log_current_level) THEN
218: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Updates complete in if');
219: END IF;

Line 326: FROM AHL_FLEET_RECONFIG_MRS

322: WHERE fleet_header_id = p_fleet_id;
323: -- Reconfig MRs
324: /* Reconfig MR processing is done already
325: DELETE
326: FROM AHL_FLEET_RECONFIG_MRS
327: WHERE fleet_header_id = p_fleet_id;*/
328: IF (l_log_statement >= l_log_current_level) THEN
329: fnd_log.string ( l_log_statement, 'ahl.plsql.Remove_Fleet', 'Updates complete in else');
330: END IF;

Line 449: FROM ahl_fleet_reconfig_mrs frm, ahl_mr_headers_v mrh

445: CURSOR get_reconfig_mrs(c_fleet_header_id NUMBER, c_src_operations_type_code VARCHAR2)
446: IS
447: SELECT frm.fleet_reconfig_mr_id, mrh.mr_header_id, frm.mr_title,
448: frm.src_operations_type_code, frm.compliance_lead_time
449: FROM ahl_fleet_reconfig_mrs frm, ahl_mr_headers_v mrh
450: WHERE frm.fleet_header_id = c_fleet_header_id
451: AND frm.mr_title = mrh.title
452: AND trunc(nvl(mrh.effective_to, SYSDATE +1))>trunc(SYSDATE)
453: AND mrh.mr_status_code = 'COMPLETE'