APPS.AHL_FMP_MR_ROUTE_PVT dependencies on AHL_MR_ROUTE_SEQUENCES

Line 472: FROM AHL_MR_ROUTE_SEQUENCES

468: p_mr_route_id in number
469: )
470: IS
471: SELECT 'X'
472: FROM AHL_MR_ROUTE_SEQUENCES
473: WHERE mr_route_id = p_mr_route_id OR related_mr_route_id = p_mr_route_id;
474:
475: BEGIN
476:

Line 593: DELETE AHL_MR_ROUTE_SEQUENCES a

589: END IF;
590:
591:
592: IF P_X_MR_ROUTE_TBL(i).DML_OPERATION='D' then
593: DELETE AHL_MR_ROUTE_SEQUENCES a
594: 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);
595:
596:
597: DELETE AHL_MR_ROUTES