APPS.PSP_XMLGEN dependencies on GMS_PERSONNEL

Line 1796: WHERE papf.person_id = (SELECT person_id FROM gms_personnel gp

1792: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),
1793: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1794: WHERE haou.organization_id = perd.expenditure_organization_id),
1795: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1796: WHERE papf.person_id = (SELECT person_id FROM gms_personnel gp
1797: WHERE gp.award_id = perd.award_id AND gp.award_role = 'PI'
1798: AND gp.start_date_active = (SELECT MAX(gp2.start_date_active)
1799: FROM gms_personnel gp2
1800: WHERE gp2.award_id = perd.award_id

Line 1799: FROM gms_personnel gp2

1795: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1796: WHERE papf.person_id = (SELECT person_id FROM gms_personnel gp
1797: WHERE gp.award_id = perd.award_id AND gp.award_role = 'PI'
1798: AND gp.start_date_active = (SELECT MAX(gp2.start_date_active)
1799: FROM gms_personnel gp2
1800: WHERE gp2.award_id = perd.award_id
1801: AND gp2.award_role = 'PI' --- added for uva fix
1802: AND nvl(gp2.end_date_active,to_date('31-12-4712','dd-mm-yyyy')) >= r_effort_report.r_start_date(I) --- uva fix
1803: AND gp2.start_date_active <= r_effort_report.r_end_date(I))