APPS.AHL_UMP_FORECAST_REQ_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 135: FROM AHL_UNIT_EFFECTIVITIES_B UE, AHL_ROUTES_B R, AHL_MR_ROUTES MR

131: */
132: CURSOR ue_mr_routes_csr (p_item_indtance_id IN NUMBER) IS
133: SELECT UE.unit_effectivity_id, UE.due_date, MR.mr_route_id, R.route_id, R.start_date_active, R.end_date_active
134: -- FROM AHL_UNIT_EFFECTIVITIES_APP_V UE, AHL_MR_ROUTES_V MR
135: FROM AHL_UNIT_EFFECTIVITIES_B UE, AHL_ROUTES_B R, AHL_MR_ROUTES MR
136: WHERE UE.mr_header_id = MR.mr_header_id
137: AND R.route_id = MR.ROUTE_ID
138: --AND MR.APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')))
139: AND UE.APPLICATION_USG_CODE = G_APP_MODULE

Line 617: FROM ahl_unit_effectivities_b

613: FROM ahl_mr_headers_b mr
614: WHERE application_usg_code = appln_usg_code
615: AND mr_status_code = 'COMPLETE'
616: AND EXISTS (SELECT 1
617: FROM ahl_unit_effectivities_b
618: WHERE mr_header_id = mr.mr_header_id
619: AND (status_code IS NULL OR status_code = 'INIT-DUE')
620: );
621:

Line 625: FROM ahl_unit_effectivities_b UE

621:
622: -- get open UE IDs for the MR header.
623: CURSOR get_ue_csr (p_mr_header_id IN NUMBER) IS
624: SELECT unit_effectivity_id, due_date, csi_item_instance_id
625: FROM ahl_unit_effectivities_b UE
626: WHERE mr_header_id = p_mr_header_id
627: AND due_date IS NOT NULL
628: AND (status_code IS NULL OR status_code = 'INIT-DUE');
629: --ORDER BY csi_item_instance_id, due_date;