APPS.AHL_FMP_MR_ROUTE_PVT dependencies on AHL_MR_ROUTE_SEQUENCES

Line 550: FROM AHL_MR_ROUTE_SEQUENCES

546: p_mr_route_id in number
547: )
548: IS
549: SELECT 'X'
550: FROM AHL_MR_ROUTE_SEQUENCES
551: WHERE mr_route_id = p_mr_route_id OR related_mr_route_id = p_mr_route_id;
552:
553: BEGIN
554:

Line 673: DELETE AHL_MR_ROUTE_SEQUENCES a

669: END IF;
670:
671:
672: IF P_X_MR_ROUTE_TBL(i).DML_OPERATION='D' then
673: DELETE AHL_MR_ROUTE_SEQUENCES a
674: where (MR_ROUTE_ID =P_X_MR_ROUTE_TBL(i).MR_ROUTE_ID or RELATED_MR_ROUTE_ID=P_X_MR_ROUTE_TBL(i).MR_ROUTE_ID);
675:
676:
677: DELETE AHL_MR_ROUTES