1591: IS
1592: SELECT AR.rt_oper_resource_id,
1593: AR.aso_resource_id,
1594: ART.name
1595: FROM AHL_RT_OPER_RESOURCES AR, AHL_RESOURCES ART
1596: WHERE AR.aso_resource_id = ART.resource_id
1597: AND AR.association_type_code=p_association_type
1598: AND AR.object_id=p_object_id;
1599:
1704: AR.scheduled_type_id,
1705: AR.autocharge_type_id,
1706: AR.standard_rate_flag,
1707: AR.schedule_seq
1708: FROM AHL_RT_OPER_RESOURCES AR
1709: WHERE AR.association_type_code='OPERATION'
1710: AND AR.object_id=c_operation_id;
1711: -- JKJAIN US space FP 7644260 for ER # 6998882 -- end
1712: l_oper_resource_rec get_oper_resources%ROWTYPE;
1886: AR.scheduled_type_id,
1887: AR.autocharge_type_id,
1888: AR.standard_rate_flag,
1889: AR.schedule_seq
1890: FROM AHL_RT_OPER_RESOURCES AR
1891: WHERE AR.association_type_code=c_association_type
1892: AND AR.object_id=c_object_id;
1893: -- JKJAIN US space FP 7644260 for ER # 6998882 -- end
1894: l_rt_oper_resource_rec get_rt_oper_resources%ROWTYPE;