DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PVT dependencies on CSD_RT_TRANS_B

Line 4611: FROM CSD_RT_TRANS_B RT_B

4607:
4608: -- CURSORS --
4609: CURSOR c_is_rt_update_allowed IS
4610: SELECT 'x'
4611: FROM CSD_RT_TRANS_B RT_B
4612: WHERE RT_B.FROM_REPAIR_TYPE_ID = p_from_repair_type_id AND
4613: RT_B.TO_REPAIR_TYPE_ID = p_to_repair_type_id AND
4614: RT_B.COMMON_FLOW_STATUS_ID = p_common_flow_status_id AND
4615: ((RT_B.ALLOW_ALL_RESP_FLAG = 'Y') OR

Line 4706: FROM CSD_RT_TRANS_B RT_TRANS

4702: -- CURSOR --
4703: CURSOR c_get_trans_flags IS
4704: SELECT RT_TRANS.reason_required_flag,
4705: RT_TRANS.capture_activity_flag
4706: FROM CSD_RT_TRANS_B RT_TRANS
4707: WHERE RT_TRANS.from_repair_type_id = p_from_repair_type_id AND
4708: RT_TRANS.to_repair_type_id = p_to_repair_type_id AND
4709: RT_TRANS.common_flow_status_id = p_common_flow_status_id;
4710: