APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_RT_OPER_RESOURCES

Line 1765: FROM AHL_RT_OPER_RESOURCES AR, AHL_RESOURCES ART

1761: IS
1762: SELECT AR.rt_oper_resource_id,
1763: AR.aso_resource_id,
1764: ART.name
1765: FROM AHL_RT_OPER_RESOURCES AR, AHL_RESOURCES ART
1766: WHERE AR.aso_resource_id = ART.resource_id
1767: AND AR.association_type_code=p_association_type
1768: AND AR.object_id=p_object_id;
1769:

Line 1878: FROM AHL_RT_OPER_RESOURCES AR

1874: AR.scheduled_type_id,
1875: AR.autocharge_type_id,
1876: AR.standard_rate_flag,
1877: AR.schedule_seq
1878: FROM AHL_RT_OPER_RESOURCES AR
1879: WHERE AR.association_type_code='OPERATION'
1880: AND AR.object_id=c_operation_id;
1881: -- JKJAIN US space FP 7644260 for ER # 6998882 -- end
1882: l_oper_resource_rec get_oper_resources%ROWTYPE;

Line 2091: FROM AHL_RT_OPER_RESOURCES AR

2087: AR.scheduled_type_id,
2088: AR.autocharge_type_id,
2089: AR.standard_rate_flag,
2090: AR.schedule_seq
2091: FROM AHL_RT_OPER_RESOURCES AR
2092: WHERE AR.association_type_code=c_association_type
2093: AND AR.object_id=c_object_id;
2094: -- JKJAIN US space FP 7644260 for ER # 6998882 -- end
2095: l_rt_oper_resource_rec get_rt_oper_resources%ROWTYPE;