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.PSP_XMLGEN dependencies on PA_PROJECT_PLAYERS

Line 1860: WHERE papf.person_id = (SELECT max(person_id) FROM pa_project_players pap

1856: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1857: WHERE haou.organization_id = perd.expenditure_organization_id),
1858: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1859: --- added max person_id for uva issue
1860: WHERE papf.person_id = (SELECT max(person_id) FROM pa_project_players pap
1861: -- WHERE pap.project_id = perd.project_id AND project_role_type = 'PROJECT MANAGER'
1862: WHERE pap.project_id = perd.project_id AND project_role_type = l_project_manager_role
1863: AND pap.start_date_active = (SELECT MAX(pap2.start_date_active)
1864: FROM pa_project_players pap2

Line 1864: FROM pa_project_players pap2

1860: WHERE papf.person_id = (SELECT max(person_id) FROM pa_project_players pap
1861: -- WHERE pap.project_id = perd.project_id AND project_role_type = 'PROJECT MANAGER'
1862: WHERE pap.project_id = perd.project_id AND project_role_type = l_project_manager_role
1863: AND pap.start_date_active = (SELECT MAX(pap2.start_date_active)
1864: FROM pa_project_players pap2
1865: WHERE pap2.project_id = perd.project_id
1866: AND pap2.project_role_type = l_project_manager_role
1867: AND nvl(pap2.end_date_active,to_date('31-12-4712','dd-mm-yyyy')) >= r_effort_report.r_start_date(I) --- uva fix
1868: AND pap2.start_date_active <= r_effort_report.r_end_date(I)))