APPS.PSP_XMLGEN dependencies on GMS_PERSONNEL

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

1821: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug 16391366
1822: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1823: WHERE haou.organization_id = perd.expenditure_organization_id),
1824: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1825: WHERE papf.person_id = (SELECT person_id FROM gms_personnel gp
1826: WHERE gp.award_id = perd.award_id AND gp.award_role = 'PI'
1827: AND gp.start_date_active = (SELECT MAX(gp2.start_date_active)
1828: FROM gms_personnel gp2
1829: WHERE gp2.award_id = perd.award_id

Line 1828: FROM gms_personnel gp2

1824: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1825: WHERE papf.person_id = (SELECT person_id FROM gms_personnel gp
1826: WHERE gp.award_id = perd.award_id AND gp.award_role = 'PI'
1827: AND gp.start_date_active = (SELECT MAX(gp2.start_date_active)
1828: FROM gms_personnel gp2
1829: WHERE gp2.award_id = perd.award_id
1830: AND gp2.award_role = 'PI' --- added for uva fix
1831: AND nvl(gp2.end_date_active,to_date('31-12-4712','dd-mm-yyyy')) >= r_effort_report.r_start_date(I) --- uva fix
1832: AND gp2.start_date_active <= r_effort_report.r_end_date(I))