APPS.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on AHL_RESOURCE_MAPPINGS

Line 1008: FROM ahl_resource_mappings

1004: --checking dept conflicts among primary resources
1005: CURSOR get_dept_conflicts ( c_object_id NUMBER, c_association_type_code VARCHAR2 )
1006: IS
1007: SELECT 'X'
1008: FROM ahl_resource_mappings
1009: WHERE DEPARTMENT_ID IS NOT NULL
1010: AND aso_resource_id in
1011: (SELECT ASO_RESOURCE_ID
1012: FROM ahl_rt_oper_resources

Line 1023: FROM ahl_resource_mappings

1019: --checking dept conflicts b/w the primary resource and alt resources of OTHER primary resources
1020: CURSOR get_dept_conflicts_alt_res ( c_object_id NUMBER, c_association_type_code VARCHAR2, c_rt_oper_res_id NUMBER)
1021: IS
1022: SELECT 'X'
1023: FROM ahl_resource_mappings
1024: WHERE DEPARTMENT_ID IS NOT NULL
1025: AND aso_resource_id in
1026: (SELECT ALTR.ASO_RESOURCE_ID
1027: FROM ahl_alternate_resources ALTR,

Line 3082: FROM ahl_resource_mappings

3078: --pdoki ER 7436910 Begin.
3079: CURSOR get_dept_conflicts ( c_object_id NUMBER, c_association_type_code VARCHAR2, c_aso_res_id NUMBER, c_alt_res_id NUMBER)
3080: IS
3081: SELECT 'X'
3082: FROM ahl_resource_mappings
3083: WHERE DEPARTMENT_ID IS NOT NULL
3084: AND aso_resource_id in
3085: (
3086: SELECT ASO_RESOURCE_ID