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 1829: WHERE papf.person_id = (SELECT max(person_id) FROM pa_project_players pap

1825: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1826: WHERE haou.organization_id = perd.expenditure_organization_id),
1827: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1828: --- added max person_id for uva issue
1829: WHERE papf.person_id = (SELECT max(person_id) FROM pa_project_players pap
1830: -- WHERE pap.project_id = perd.project_id AND project_role_type = 'PROJECT MANAGER'
1831: WHERE pap.project_id = perd.project_id AND project_role_type = l_project_manager_role
1832: AND pap.start_date_active = (SELECT MAX(pap2.start_date_active)
1833: FROM pa_project_players pap2

Line 1833: FROM pa_project_players pap2

1829: WHERE papf.person_id = (SELECT max(person_id) FROM pa_project_players pap
1830: -- WHERE pap.project_id = perd.project_id AND project_role_type = 'PROJECT MANAGER'
1831: WHERE pap.project_id = perd.project_id AND project_role_type = l_project_manager_role
1832: AND pap.start_date_active = (SELECT MAX(pap2.start_date_active)
1833: FROM pa_project_players pap2
1834: WHERE pap2.project_id = perd.project_id
1835: AND pap2.project_role_type = l_project_manager_role
1836: AND nvl(pap2.end_date_active,to_date('31-12-4712','dd-mm-yyyy')) >= r_effort_report.r_start_date(I) --- uva fix
1837: AND pap2.start_date_active <= r_effort_report.r_end_date(I)))