APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_MR_ROUTES

Line 1115: FROM AHL_MR_ROUTES

1111:
1112: IF p_mr_header_rec.TYPE_CODE='PROGRAM' and l_mr_rec.type_code='ACTIVITY'
1113: THEN
1114: SELECT COUNT(*) INTO l_counter
1115: FROM AHL_MR_ROUTES
1116: WHERE MR_HEADER_ID=p_mr_header_rec.MR_HEADER_ID;
1117:
1118: IF l_counter >0
1119: THEN

Line 1276: from ahl_mr_routes mrr, ahl_routes_b rm

1272: c_mr_header_id number
1273: )
1274: IS
1275: select 'x'
1276: from ahl_mr_routes mrr, ahl_routes_b rm
1277: where mrr.route_id = rm.route_id and
1278: nvl(rm.route_type_code, 'X') not in ('M_PROC','O_PROC') and
1279: mrr.mr_header_id = c_mr_header_id;
1280:

Line 2688: Select * from ahl_mr_Routes

2684: l_return_status VARCHAR2(1);
2685: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;
2686: Cursor CurGetRoutes(c_mr_header_id number)
2687: Is
2688: Select * from ahl_mr_Routes
2689: Where mr_header_id=c_mr_header_id;
2690: l_mr_route_rec CurGetRoutes%rowtype;
2691:
2692: Cursor curGetMrEffects(c_mr_header_id number)

Line 2798: Delete AHL_MR_ROUTES

2794: Delete AHL_MR_ROUTE_SEQUENCES
2795: WHERE MR_ROUTE_ID=l_mr_route_rec.mr_route_id or
2796: RELATED_MR_ROUTE_ID=l_mr_route_rec.mr_route_id;
2797:
2798: Delete AHL_MR_ROUTES
2799: WHERE MR_ROUTE_ID=l_mr_route_rec.mr_route_id;
2800: End if;
2801: End loop;
2802: Close CurGetRoutes;