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

690:
691: /* Start of Changes for Bug 6056112 */
692: SELECT nvl(future_term_wf_flag,'N')
693: INTO l_future_term_wf_flag
694: FROM pa_resources
695: WHERE resource_id = l_assignment_rec.resource_id;
696:
697: IF (nvl(l_future_term_wf_flag,'N') = 'Y') THEN
698:

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

1349: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;
1350: l_project_role_id_tmp pa_project_assignments.project_role_id%TYPE;
1351: l_assignment_name_tmp pa_project_assignments.assignment_name%TYPE;
1352: l_person_type_code Varchar2(30);
1353: l_future_term_wf_flag pa_resources.future_term_wf_flag%TYPE := NULL ; --Added for Bug 6056112
1354:
1355: CURSOR assignment_status_code_csr
1356: IS
1357: SELECT status_code, start_date, end_date

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

1623:
1624: /* Start of Changes for Bug 6056112 */
1625: SELECT nvl(future_term_wf_flag,'N')
1626: INTO l_future_term_wf_flag
1627: FROM pa_resources
1628: WHERE resource_id = l_assignment_rec.resource_id;
1629:
1630:
1631: IF (nvl(l_future_term_wf_flag,'N') = 'Y') THEN

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: