APPS.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on AHL_RESOURCES

Line 459: FROM AHL_RESOURCES

455: -- Added for bug# 6512803.
456: CURSOR get_res_type_id( c_resource_id In NUMBER)
457: IS
458: SELECT resource_type_id
459: FROM AHL_RESOURCES
460: WHERE resource_id = c_resource_id;
461:
462: l_resource_type_id NUMBER;
463:

Line 900: FROM AHL_RESOURCES

896:
897: CURSOR check_resource_type( c_aso_resource_id NUMBER, c_resource_type_id NUMBER )
898: IS
899: SELECT 'X'
900: FROM AHL_RESOURCES
901: WHERE resource_id = c_aso_resource_id
902: AND resource_type_id = c_resource_type_id;
903:
904: -- Added to fix bug# 6512803.

Line 2079: FROM AHL_RT_OPER_RESOURCES RES, AHL_RESOURCES AR

2075: RES.ASSOCIATION_TYPE_CODE,
2076: AR.resource_type_id,
2077: RES.duration,
2078: AR.NAME
2079: FROM AHL_RT_OPER_RESOURCES RES, AHL_RESOURCES AR
2080: WHERE RES.aso_resource_id = AR.resource_id
2081: AND RES.RT_OPER_RESOURCE_ID = C_RT_OPER_RESOURCE_ID;
2082:
2083: cursor get_route_status (p_route_id in number)

Line 2111: l_name ahl_resources.name%TYPE;

2107: -- Added for bug fix# 6512803.
2108: l_resource_type_id NUMBER;
2109: l_max_rt_time_span NUMBER;
2110: l_duration NUMBER;
2111: l_name ahl_resources.name%TYPE;
2112:
2113: BEGIN
2114: -- Initialize API return status to success
2115: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2225: -- default here to avoid query on ahl_resources.

2221: END IF;
2222: END IF;
2223:
2224: ELSIF (p_x_rt_oper_cost_rec.scheduled_type_id = FND_API.G_MISS_NUM) THEN
2225: -- default here to avoid query on ahl_resources.
2226: IF (l_resource_type_id IN (1,2)) THEN
2227: p_x_rt_oper_cost_rec.scheduled_type_id := 1;
2228: ELSE
2229: p_x_rt_oper_cost_rec.scheduled_type_id := 2;

Line 2965: FROM AHL_RESOURCES

2961:
2962: CURSOR check_resource_type2( c_aso_resource_id NUMBER)
2963: IS
2964: SELECT resource_type_id
2965: FROM AHL_RESOURCES
2966: WHERE resource_id = c_aso_resource_id;
2967: BEGIN
2968: x_return_status := FND_API.G_RET_STS_SUCCESS;
2969: OPEN check_resource_type1( p_rt_oper_resource_id);