APPS.PA_PROJECT_PARTIES_PVT dependencies on PA_RESOURCES_DENORM

Line 123: SELECT 'Y' INTO l_is_valid_denorm FROM pa_resources_denorm

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