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_RESOURCE_UTILS dependencies on PA_PROJECT_ASSIGNMENTS

Line 1929: FROM pa_project_assignments

1925: --Get the assignment start date
1926: BEGIN
1927: SELECT start_date
1928: INTO l_start_date
1929: FROM pa_project_assignments
1930: WHERE assignment_id = p_assignment_id
1931: ;
1932: EXCEPTION
1933: WHEN OTHERS THEN

Line 2505: pa_project_assignments asgmt,

2501: proj.project_id
2502: INTO l_proj_name_number,
2503: l_project_id
2504: FROM --pa_resources_denorm res,
2505: pa_project_assignments asgmt,
2506: pa_projects_all proj,
2507: pa_project_statuses ps
2508: WHERE --trunc(sysdate) between trunc(res.resource_effective_start_date)
2509: -- and trunc(res.resource_effective_end_date)

Line 4671: FROM pa_project_assignments

4667: --Get the assignment start date
4668: BEGIN
4669: SELECT start_date
4670: INTO l_start_date
4671: FROM pa_project_assignments
4672: WHERE assignment_id = p_assignment_id
4673: ;
4674: EXCEPTION
4675: WHEN OTHERS THEN