APPS.PA_PROJECT_PARTIES_PVT dependencies on PA_RESOURCES_DENORM

Line 125: SELECT 'Y' INTO l_is_valid_denorm FROM pa_resources_denorm

121: X_RETURN_STATUS => l_return_status);
122:
123: /* Added for bug 6077424*/
124: BEGIN
125: SELECT 'Y' INTO l_is_valid_denorm FROM pa_resources_denorm
126: WHERE person_id = p_resource_source_id
127: AND rownum=1;
128: EXCEPTION
129: WHEN NO_DATA_FOUND THEN

Line 251: FROM pa_resources_denorm

247: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
248: IF(NVL(l_past_resource,'XXX') = 'Y') THEN --Added for Bug 8811314
249: SELECT max(resource_effective_end_date)
250: INTO l_date
251: FROM pa_resources_denorm
252: WHERE resource_id = l_resource_id ;
253: else
254: l_date :=pa_resource_utils.Get_Resource_Effective_Date(p_resource_id => l_resource_id);
255: end if;

Line 636: FROM pa_resources_denorm

632: -- Added for bug 3149239
633: IF(NVL(l_past_resource,'XXX') = 'Y') THEN --Added for bug 8811314
634: SELECT max(resource_effective_end_date)
635: INTO l_date
636: FROM pa_resources_denorm
637: WHERE resource_id = l_resource_id ;
638: else
639: l_date :=pa_resource_utils.Get_Resource_Effective_Date(p_resource_id => p_resource_id);
640: end if;