DBA Data[Home] [Help]

APPS.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on AHL_ALTERNATE_RESOURCES_V

Line 3005: FROM AHL_ALTERNATE_RESOURCES_V

3001:
3002: CURSOR get_dup_rec1 (c_rt_oper_resource_id number)
3003: IS
3004: SELECT name
3005: FROM AHL_ALTERNATE_RESOURCES_V
3006: WHERE rt_oper_resource_id = c_rt_oper_resource_id
3007: GROUP BY NAME
3008: HAVING count(*) > 1;
3009:

Line 3032: from AHL_alternate_resources_v

3028:
3029: CURSOR get_alt_res_name (c_rt_oper_resource_id number, c_aso_resource_name varchar2)
3030: IS
3031: select name
3032: from AHL_alternate_resources_v
3033: where rt_oper_resource_id = c_rt_oper_resource_id
3034: and name = c_aso_resource_name;
3035:
3036: --pdoki ER 7436910 Begin.