eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_RESOURCES

Line 21: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895

17: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
19: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
20: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
21: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895
22: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23: )
24: IS
25:

Line 82: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL; -- Added for Bug 6056112

78: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
79: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
80: l_person_type_code Varchar2(30);
81: l_future_dated_emp Varchar2(1);
82: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL; -- Added for Bug 6056112
83:
84: CURSOR get_resource_source_id IS
85: SELECT person_id
86: FROM pa_resource_txn_attributes

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 663: FROM pa_resources

659:
660: /* Start of Changes for Bug 6056112 */
661: SELECT nvl(future_term_wf_flag,'N')
662: INTO l_future_term_wf_flag
663: FROM pa_resources
664: WHERE resource_id = l_assignment_rec.resource_id;
665:
666: IF (nvl(l_future_term_wf_flag,'N') = 'Y') THEN
667:

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 1322: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL ; --Added for Bug 6056112

1318: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1319: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1320: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1321: l_person_type_code Varchar2(30);
1322: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL ; --Added for Bug 6056112
1323:
1324: CURSOR assignment_status_code_csr
1325: IS
1326: SELECT status_code, start_date, end_date

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 1596: FROM pa_resources

1592:
1593: /* Start of Changes for Bug 6056112 */
1594: SELECT nvl(future_term_wf_flag,'N')
1595: INTO l_future_term_wf_flag
1596: FROM pa_resources
1597: WHERE resource_id = l_assignment_rec.resource_id;
1598:
1599:
1600: IF (nvl(l_future_term_wf_flag,'N') = 'Y') THEN

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: