APPS.AHL_RM_RT_OP_DEP_PVT dependencies on AHL_ROUTE_OPERATIONS

Line 476: FROM ahl_route_operations ro,ahl_operations_vl op

472: -- Cursor for selecting route_operation_association_id.
473: CURSOR get_route_oper_id(c_operation_step NUMBER, c_operation_number VARCHAR2, c_operation_status VARCHAR2, c_route_id NUMBER)
474: IS
475: SELECT route_operation_id
476: FROM ahl_route_operations ro,ahl_operations_vl op
477: WHERE ro.operation_id = op.operation_id
478: AND ro.route_id = c_route_id
479: AND ro.step = c_operation_step
480: AND op.concatenated_segments = c_operation_number

Line 558: FROM ahl_route_operations

554: FROM ahl_rt_oper_dependencies od
555: WHERE --dependency_code = p_dependency_code and -- sansatpa commented this for bug #14135529
556: from_rt_op_id
557: IN ( SELECT route_operation_id
558: FROM ahl_route_operations
559: WHERE ROUTE_ID =p_route_id
560: AND route_operation_id =od.from_rt_op_id
561: )
562: START WITH to_rt_op_id = p_from_rt_op_id

Line 639: FROM AHL_ROUTE_OPERATIONS

635:
636: CURSOR validate_oper_step(c_route_id NUMBER, c_route_operation_id NUMBER)
637: IS
638: SELECT step
639: FROM AHL_ROUTE_OPERATIONS
640: WHERE route_id = c_route_id
641: AND route_operation_id = c_route_operation_id ;
642:
643: CURSOR validate_depen_ovn(c_rt_op_dependency_id NUMBER, c_object_version_number NUMBER)