APPS.AHL_RM_RT_OP_DEP_PVT dependencies on AHL_RT_OPER_DEPENDENCIES_V

Line 20: FROM ahl_rt_oper_dependencies_v

16: SELECT rt_op_dependency_id, from_rt_op_id, from_op_step, dependency_code, to_rt_op_id,
17: to_op_step, security_group_id, attribute_category, attribute1, attribute2, attribute3,
18: attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, attribute10,
19: attribute11, attribute12, attribute13, attribute14, attribute15
20: FROM ahl_rt_oper_dependencies_v
21: WHERE rt_op_dependency_id = c_rt_op_dependency_id;
22:
23: l_opdep_rec get_dep_details%rowtype;
24: l_api_name CONSTANT VARCHAR2(30) := 'default_missing_attributes';

Line 653: FROM ahl_rt_oper_dependencies_v

649:
650: CURSOR duplicate_depen(c_route_id NUMBER,c_from_rt_op_id NUMBER,c_to_rt_op_id NUMBER,c_dependency_code VARCHAR2)
651: IS
652: SELECT 'X'
653: FROM ahl_rt_oper_dependencies_v
654: WHERE route_id = c_route_id
655: -- Modified by sansatpa to check for flipped addition as A parallel to B is same as B parallel to A.
656: AND ((FROM_RT_OP_ID = C_FROM_RT_OP_ID AND TO_RT_OP_ID = C_TO_RT_OP_ID)
657: or (FROM_RT_OP_ID = C_TO_RT_OP_ID AND TO_RT_OP_ID = C_FROM_RT_OP_ID));