APPS.AHL_RM_ASO_RESOURCE_PVT dependencies on AHL_RT_OPER_RESOURCES

Line 982: FROM ahl_rt_oper_resources

978:
979: --pdoki ER 7436910 Begin.
980: CURSOR get_rt_oper_res_obj (c_aso_resource_id number) IS
981: SELECT DISTINCT object_id, association_type_code
982: FROM ahl_rt_oper_resources
983: WHERE aso_resource_id = c_aso_resource_id;
984: --checking dept conflicts among primary resources
985: CURSOR get_dept_conflicts ( c_object_id NUMBER, c_association_type_code VARCHAR2 )
986: IS

Line 992: FROM ahl_rt_oper_resources

988: FROM ahl_resource_mappings
989: WHERE DEPARTMENT_ID IS NOT NULL
990: AND aso_resource_id in
991: (SELECT ASO_RESOURCE_ID
992: FROM ahl_rt_oper_resources
993: WHERE object_id = c_object_id
994: AND ASSOCIATION_TYPE_CODE = c_association_type_code
995: )
996: GROUP BY bom_org_id

Line 1009: FROM ahl_rt_oper_resources

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
1012: AND OBJECT_ID = c_object_id
1013: )

Line 1019: FROM ahl_rt_oper_resources

1015: WHERE ROR.RT_OPER_RESOURCE_ID = ALTR.rt_oper_resource_id
1016: )
1017: OR aso_resource_id =
1018: (SELECT aso_resource_id
1019: FROM ahl_rt_oper_resources
1020: WHERE RT_OPER_RESOURCE_ID = c_rt_oper_res_id
1021: )
1022: GROUP BY bom_org_id
1023: HAVING count(DISTINCT DEPARTMENT_ID) > 1;

Line 1028: FROM AHL_RT_OPER_RESOURCES

1024:
1025: CURSOR get_rt_oper_res_ids ( c_object_id NUMBER, c_association_type_code VARCHAR2)
1026: IS
1027: SELECT RT_OPER_RESOURCE_ID
1028: FROM AHL_RT_OPER_RESOURCES
1029: WHERE ASSOCIATION_TYPE_CODE = c_association_type_code
1030: AND OBJECT_ID = c_object_id;
1031:
1032: --checks for conflicts b/w the alternate resource and other primary resources. here the resource is an alternate resource(in alternate_resources table)

Line 1041: FROM ahl_rt_oper_resources

1037: WHERE DEPARTMENT_ID IS NOT NULL
1038: AND aso_resource_id in
1039: (
1040: SELECT ASO_RESOURCE_ID
1041: FROM ahl_rt_oper_resources
1042: WHERE object_id = c_object_id
1043: AND ASSOCIATION_TYPE_CODE = c_association_type_code
1044: AND ASO_RESOURCE_ID <> c_aso_res_id
1045: )

Line 1053: FROM AHL_RT_OPER_RESOURCES

1049:
1050: CURSOR get_rt_oper_res_det (c_rt_oper_resource_id number)
1051: IS
1052: SELECT OBJECT_ID,ASSOCIATION_TYPE_CODE, ASO_RESOURCE_ID
1053: FROM AHL_RT_OPER_RESOURCES
1054: WHERE RT_OPER_RESOURCE_ID= c_rt_oper_resource_id;
1055:
1056: CURSOR get_alt_res_rt_oper_ids(c_aso_resource_id number)
1057: IS

Line 1200: FROM ahl_rt_oper_resources

1196: l_resource_mapping_id NUMBER;
1197:
1198: CURSOR check_aso_resource_used(c_resource_id NUMBER) IS
1199: SELECT aso_resource_id
1200: FROM ahl_rt_oper_resources
1201: WHERE aso_resource_id = c_resource_id;
1202:
1203: BEGIN
1204: -- Initialize API return status to success