DBA Data[Home] [Help]

APPS.AHL_RM_ASO_RESOURCE_PVT dependencies on AHL_ALTERNATE_RESOURCES

Line 1007: FROM ahl_alternate_resources ALTR,

1003: FROM ahl_resource_mappings
1004: WHERE DEPARTMENT_ID IS NOT NULL
1005: AND aso_resource_id in
1006: (SELECT ALTR.ASO_RESOURCE_ID
1007: FROM ahl_alternate_resources ALTR,
1008: (SELECT RT_OPER_RESOURCE_ID
1009: FROM ahl_rt_oper_resources
1010: WHERE RT_OPER_RESOURCE_ID <> c_rt_oper_res_id
1011: AND ASSOCIATION_TYPE_CODE = c_association_type_code

Line 1059: from ahl_alternate_resources

1055:
1056: CURSOR get_alt_res_rt_oper_ids(c_aso_resource_id number)
1057: IS
1058: select RT_OPER_RESOURCE_ID
1059: from ahl_alternate_resources
1060: where ASO_RESOURCE_ID= c_aso_resource_id;
1061:
1062: l_aso_res_id NUMBER;
1063: l_alt_res_rt_oper_id NUMBER;