APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_MR_ROUTES

Line 985: FROM AHL_MR_ROUTES

981:
982: IF p_mr_header_rec.TYPE_CODE='PROGRAM' and l_mr_rec.type_code='ACTIVITY'
983: THEN
984: SELECT COUNT(*) INTO l_counter
985: FROM AHL_MR_ROUTES
986: WHERE MR_HEADER_ID=p_mr_header_rec.MR_HEADER_ID;
987:
988: IF l_counter >0
989: THEN

Line 1146: from ahl_mr_routes mrr, ahl_routes_b rm

1142: c_mr_header_id number
1143: )
1144: IS
1145: select 'x'
1146: from ahl_mr_routes mrr, ahl_routes_b rm
1147: where mrr.route_id = rm.route_id and
1148: nvl(rm.route_type_code, 'X') not in ('M_PROC','O_PROC') and
1149: mrr.mr_header_id = c_mr_header_id;
1150:

Line 2344: Select * from ahl_mr_Routes

2340: l_return_status VARCHAR2(1);
2341: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;
2342: Cursor CurGetRoutes(c_mr_header_id number)
2343: Is
2344: Select * from ahl_mr_Routes
2345: Where mr_header_id=c_mr_header_id;
2346: l_mr_route_rec CurGetRoutes%rowtype;
2347:
2348: Cursor curGetMrEffects(c_mr_header_id number)

Line 2427: Delete AHL_MR_ROUTES

2423: Delete AHL_MR_ROUTE_SEQUENCES
2424: WHERE MR_ROUTE_ID=l_mr_route_rec.mr_route_id or
2425: RELATED_MR_ROUTE_ID=l_mr_route_rec.mr_route_id;
2426:
2427: Delete AHL_MR_ROUTES
2428: WHERE MR_ROUTE_ID=l_mr_route_rec.mr_route_id;
2429: End if;
2430: End loop;
2431: Close CurGetRoutes;