DBA Data[Home] [Help]

APPS.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on AHL_ALTERNATE_RESOURCES_V

Line 3047: FROM AHL_ALTERNATE_RESOURCES_V

3043:
3044: CURSOR get_dup_rec1 (c_rt_oper_resource_id number)
3045: IS
3046: SELECT name
3047: FROM AHL_ALTERNATE_RESOURCES_V
3048: WHERE rt_oper_resource_id = c_rt_oper_resource_id
3049: GROUP BY NAME
3050: HAVING count(*) > 1;
3051:

Line 3074: from AHL_alternate_resources_v

3070:
3071: CURSOR get_alt_res_name (c_rt_oper_resource_id number, c_aso_resource_name varchar2)
3072: IS
3073: select name
3074: from AHL_alternate_resources_v
3075: where rt_oper_resource_id = c_rt_oper_resource_id
3076: and name = c_aso_resource_name;
3077:
3078: --pdoki ER 7436910 Begin.