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 476: -- pa_resources_denorm table on the assignment start date

472: x_resource_id := l_assignment_rec.resource_id;
473: END IF;
474:
475: --Bug 2229861: Check if the resource records are pulled into
476: -- pa_resources_denorm table on the assignment start date
477: l_check_resource := FND_API.G_RET_STS_SUCCESS;
478:
479: PA_RESOURCE_UTILS.Validate_Person (
480: p_person_id => l_resource_source_id

Line 644: FROM pa_resources_denorm

640: END IF;
641:
642: SELECT person_id
643: INTO l_person_id
644: FROM pa_resources_denorm
645: WHERE resource_id = l_assignment_rec.resource_id
646: AND rownum = 1;
647:
648: exception

Line 701: FROM pa_resources_denorm prd

697: IF (nvl(l_future_term_wf_flag,'N') = 'Y') THEN
698:
699: SELECT job_id
700: INTO l_fcst_job_id_tmp
701: FROM pa_resources_denorm prd
702: WHERE prd.person_id = l_person_id_tmp
703: AND l_assignment_rec.start_date BETWEEN prd.resource_effective_start_date
704: AND prd.resource_effective_end_date ;
705:

Line 1450: FROM pa_resources_denorm

1446:
1447: -- get the resource's organization in HR
1448: CURSOR get_resource_organization IS
1449: SELECT resource_organization_id
1450: FROM pa_resources_denorm
1451: WHERE l_assignment_rec.start_date BETWEEN resource_effective_start_date AND resource_effective_end_date
1452: AND resource_id = l_assignment_rec.resource_id;
1453:
1454:

Line 1572: FROM pa_resources_denorm

1568:
1569:
1570: SELECT person_id
1571: INTO l_person_id
1572: FROM pa_resources_denorm
1573: WHERE resource_id = p_assignment_rec.resource_id
1574: AND rownum = 1;
1575:
1576: exception

Line 1635: FROM pa_resources_denorm prd

1631: IF (nvl(l_future_term_wf_flag,'N') = 'Y') THEN
1632:
1633: SELECT job_id
1634: INTO l_fcst_job_id_tmp
1635: FROM pa_resources_denorm prd
1636: WHERE prd.person_id = l_person_id_tmp
1637: AND l_assignment_rec.start_date BETWEEN prd.resource_effective_start_date
1638: AND prd.resource_effective_end_date ;
1639:

Line 2181: pa_resources_denorm res

2177:
2178: CURSOR get_start_end_date IS
2179: SELECT asgn.start_date, asgn.end_date, asgn.project_id, res.person_id
2180: FROM pa_project_assignments asgn,
2181: pa_resources_denorm res
2182: WHERE assignment_id = p_assignment_id
2183: AND res.resource_id = asgn.resource_id
2184: AND rownum=1;
2185: