APPS.AHL_RM_ASO_RESOURCE_PVT dependencies on AHL_RT_OPER_RESOURCES

Line 1008: FROM ahl_rt_oper_resources

1004:
1005: --pdoki ER 7436910 Begin.
1006: CURSOR get_rt_oper_res_obj (c_aso_resource_id number) IS
1007: SELECT DISTINCT object_id, association_type_code
1008: FROM ahl_rt_oper_resources
1009: WHERE aso_resource_id = c_aso_resource_id;
1010:
1011: --checking dept conflicts among primary resources
1012: CURSOR get_dept_conflicts ( c_object_id NUMBER, c_association_type_code VARCHAR2 )

Line 1019: FROM ahl_rt_oper_resources

1015: FROM ahl_resource_mappings
1016: WHERE DEPARTMENT_ID IS NOT NULL
1017: AND aso_resource_id in
1018: (SELECT ASO_RESOURCE_ID
1019: FROM ahl_rt_oper_resources
1020: WHERE object_id = c_object_id
1021: AND ASSOCIATION_TYPE_CODE = c_association_type_code
1022: )
1023: GROUP BY bom_org_id

Line 1036: FROM ahl_rt_oper_resources

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
1039: AND OBJECT_ID = c_object_id
1040: )

Line 1046: FROM ahl_rt_oper_resources

1042: WHERE ROR.RT_OPER_RESOURCE_ID = ALTR.rt_oper_resource_id
1043: )
1044: OR aso_resource_id =
1045: (SELECT aso_resource_id
1046: FROM ahl_rt_oper_resources
1047: WHERE RT_OPER_RESOURCE_ID = c_rt_oper_res_id
1048: )
1049: GROUP BY bom_org_id
1050: HAVING count(DISTINCT DEPARTMENT_ID) > 1;

Line 1055: FROM AHL_RT_OPER_RESOURCES

1051:
1052: CURSOR get_rt_oper_res_ids ( c_object_id NUMBER, c_association_type_code VARCHAR2)
1053: IS
1054: SELECT RT_OPER_RESOURCE_ID
1055: FROM AHL_RT_OPER_RESOURCES
1056: WHERE ASSOCIATION_TYPE_CODE = c_association_type_code
1057: AND OBJECT_ID = c_object_id;
1058:
1059: --checks for conflicts b/w the alternate resource and other primary resources. here the resource is an alternate resource(in alternate_resources table)

Line 1068: FROM ahl_rt_oper_resources

1064: WHERE DEPARTMENT_ID IS NOT NULL
1065: AND aso_resource_id in
1066: (
1067: SELECT ASO_RESOURCE_ID
1068: FROM ahl_rt_oper_resources
1069: WHERE object_id = c_object_id
1070: AND ASSOCIATION_TYPE_CODE = c_association_type_code
1071: AND ASO_RESOURCE_ID <> c_aso_res_id
1072: )

Line 1080: FROM AHL_RT_OPER_RESOURCES

1076:
1077: CURSOR get_rt_oper_res_det (c_rt_oper_resource_id number)
1078: IS
1079: SELECT OBJECT_ID,ASSOCIATION_TYPE_CODE, ASO_RESOURCE_ID
1080: FROM AHL_RT_OPER_RESOURCES
1081: WHERE RT_OPER_RESOURCE_ID= c_rt_oper_resource_id;
1082:
1083: CURSOR get_alt_res_rt_oper_ids(c_aso_resource_id number)
1084: IS

Line 1279: FROM ahl_rt_oper_resources

1275: l_resource_mapping_id NUMBER;
1276:
1277: CURSOR check_aso_resource_used(c_resource_id NUMBER) IS
1278: SELECT aso_resource_id
1279: FROM ahl_rt_oper_resources
1280: WHERE aso_resource_id = c_resource_id;
1281:
1282: BEGIN
1283: -- Initialize API return status to success