DBA Data[Home] [Help]

APPS.AHL_RM_ASO_RESOURCE_PVT dependencies on AHL_ALTERNATE_RESOURCES

Line 1034: FROM ahl_alternate_resources ALTR,

1030: FROM ahl_resource_mappings
1031: WHERE DEPARTMENT_ID IS NOT NULL
1032: AND aso_resource_id in
1033: (SELECT ALTR.ASO_RESOURCE_ID
1034: FROM ahl_alternate_resources ALTR,
1035: (SELECT RT_OPER_RESOURCE_ID
1036: FROM ahl_rt_oper_resources
1037: WHERE RT_OPER_RESOURCE_ID <> c_rt_oper_res_id
1038: AND ASSOCIATION_TYPE_CODE = c_association_type_code

Line 1086: from ahl_alternate_resources

1082:
1083: CURSOR get_alt_res_rt_oper_ids(c_aso_resource_id number)
1084: IS
1085: select RT_OPER_RESOURCE_ID
1086: from ahl_alternate_resources
1087: where ASO_RESOURCE_ID= c_aso_resource_id;
1088:
1089: --pekambar ER # 9014609 -- Start
1090: CURSOR get_one_bomres_org_value(c_aso_resource_id number)