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 2004: FROM AHL_RT_OPER_RESOURCES_V

2000: autocharge_type_id,
2001: autocharge_type,
2002: standard_rate_flag,
2003: standard_rate
2004: FROM AHL_RT_OPER_RESOURCES_V
2005: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
2006:
2007: BEGIN
2008:

Line 3001: FROM AHL_RT_OPER_RESOURCES_V

2997:
2998: CURSOR check_resource_type1( c_rt_oper_resource_id NUMBER)
2999: IS
3000: SELECT resource_type_id
3001: FROM AHL_RT_OPER_RESOURCES_V
3002: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
3003:
3004: CURSOR check_resource_type2( c_aso_resource_id NUMBER)
3005: IS

Line 3068: from ahl_rt_oper_resources_v

3064:
3065: CURSOR get_primary_res_name (c_rt_oper_resource_id number)
3066: IS
3067: SELECT aso_resource_name
3068: from ahl_rt_oper_resources_v
3069: where rt_oper_resource_id = c_rt_oper_resource_id;
3070:
3071: CURSOR get_alt_res_name (c_rt_oper_resource_id number, c_aso_resource_name varchar2)
3072: IS