APPS.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on AHL_RT_OPER_RESOURCES_V

Line 695: FROM AHL_RT_OPER_RESOURCES_V

691: IS
692: SELECT resource_type_id,
693: resource_type,
694: aso_resource_name
695: FROM AHL_RT_OPER_RESOURCES_V
696: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
697: l_old_rt_oper_resource_rec rt_oper_resource_rec_type;
698:
699: CURSOR alternate_resource_csr( c_rt_oper_resource_id NUMBER)

Line 994: FROM AHL_RT_OPER_RESOURCES_V

990: SELECT resource_type_id,
991: resource_type,
992: aso_resource_id,
993: aso_resource_name
994: FROM AHL_RT_OPER_RESOURCES_V
995: WHERE object_id = c_object_id
996: AND association_type_code = c_association_type_code
997: GROUP BY resource_type_id,
998: resource_type,

Line 1962: FROM AHL_RT_OPER_RESOURCES_V

1958: autocharge_type_id,
1959: autocharge_type,
1960: standard_rate_flag,
1961: standard_rate
1962: FROM AHL_RT_OPER_RESOURCES_V
1963: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
1964:
1965: BEGIN
1966:

Line 2959: FROM AHL_RT_OPER_RESOURCES_V

2955:
2956: CURSOR check_resource_type1( c_rt_oper_resource_id NUMBER)
2957: IS
2958: SELECT resource_type_id
2959: FROM AHL_RT_OPER_RESOURCES_V
2960: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
2961:
2962: CURSOR check_resource_type2( c_aso_resource_id NUMBER)
2963: IS

Line 3026: from ahl_rt_oper_resources_v

3022:
3023: CURSOR get_primary_res_name (c_rt_oper_resource_id number)
3024: IS
3025: SELECT aso_resource_name
3026: from ahl_rt_oper_resources_v
3027: where rt_oper_resource_id = c_rt_oper_resource_id;
3028:
3029: CURSOR get_alt_res_name (c_rt_oper_resource_id number, c_aso_resource_name varchar2)
3030: IS