DBA Data[Home] [Help]

APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_RT_OPER_RESOURCES

Line 326: FROM AHL_RT_OPER_RESOURCES

322: CURSOR get_op_max_duration( c_operation_id NUMBER )
323: IS
324: SELECT NVL(SUM(RES_DURATION),0)
325: FROM ( SELECT MAX( duration ) RES_DURATION
326: FROM AHL_RT_OPER_RESOURCES
327: WHERE association_type_code = 'OPERATION'
328: AND scheduled_type_id = 1
329: AND object_id = c_operation_id
330: GROUP BY schedule_seq