APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_RESOURCES_DENORM

Line 155: FROM pa_resources_denorm

151:
152: -- get the resource's organization in HR
153: CURSOR get_resource_organization IS
154: SELECT resource_organization_id
155: FROM pa_resources_denorm
156: WHERE l_assignment_rec.start_date BETWEEN resource_effective_start_date AND resource_effective_end_date
157: AND resource_id = l_assignment_rec.resource_id;
158:
159: CURSOR check_future_dated_employee IS

Line 445: -- pa_resources_denorm table on the assignment start date

441: x_resource_id := l_assignment_rec.resource_id;
442: END IF;
443:
444: --Bug 2229861: Check if the resource records are pulled into
445: -- pa_resources_denorm table on the assignment start date
446: l_check_resource := FND_API.G_RET_STS_SUCCESS;
447:
448: PA_RESOURCE_UTILS.Validate_Person (
449: p_person_id => l_resource_source_id

Line 613: FROM pa_resources_denorm

609: END IF;
610:
611: SELECT person_id
612: INTO l_person_id
613: FROM pa_resources_denorm
614: WHERE resource_id = l_assignment_rec.resource_id
615: AND rownum = 1;
616:
617: exception

Line 670: FROM pa_resources_denorm prd

666: IF (nvl(l_future_term_wf_flag,'N') = 'Y') THEN
667:
668: SELECT job_id
669: INTO l_fcst_job_id_tmp
670: FROM pa_resources_denorm prd
671: WHERE prd.person_id = l_person_id_tmp
672: AND l_assignment_rec.start_date BETWEEN prd.resource_effective_start_date
673: AND prd.resource_effective_end_date ;
674:

Line 1419: FROM pa_resources_denorm

1415:
1416: -- get the resource's organization in HR
1417: CURSOR get_resource_organization IS
1418: SELECT resource_organization_id
1419: FROM pa_resources_denorm
1420: WHERE l_assignment_rec.start_date BETWEEN resource_effective_start_date AND resource_effective_end_date
1421: AND resource_id = l_assignment_rec.resource_id;
1422:
1423:

Line 1541: FROM pa_resources_denorm

1537:
1538:
1539: SELECT person_id
1540: INTO l_person_id
1541: FROM pa_resources_denorm
1542: WHERE resource_id = p_assignment_rec.resource_id
1543: AND rownum = 1;
1544:
1545: exception

Line 1604: FROM pa_resources_denorm prd

1600: IF (nvl(l_future_term_wf_flag,'N') = 'Y') THEN
1601:
1602: SELECT job_id
1603: INTO l_fcst_job_id_tmp
1604: FROM pa_resources_denorm prd
1605: WHERE prd.person_id = l_person_id_tmp
1606: AND l_assignment_rec.start_date BETWEEN prd.resource_effective_start_date
1607: AND prd.resource_effective_end_date ;
1608:

Line 2144: pa_resources_denorm res

2140:
2141: CURSOR get_start_end_date IS
2142: SELECT asgn.start_date, asgn.end_date, asgn.project_id, res.person_id
2143: FROM pa_project_assignments asgn,
2144: pa_resources_denorm res
2145: WHERE assignment_id = p_assignment_id
2146: AND res.resource_id = asgn.resource_id
2147: AND rownum=1;
2148: