APPS.PSP_XMLGEN dependencies on PER_ALL_PEOPLE_F

Line 1795: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf

1791: WHERE gaa.award_id = perd.award_id),
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

Line 1827: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf

1823: WHERE gaa.award_id = perd.award_id),
1824: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),
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

Line 1860: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf

1856: WHERE gaa.award_id = perd.award_id),
1857: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),
1858: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1859: WHERE haou.organization_id = perd.expenditure_organization_id),
1860: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1861: WHERE papf.person_id = (select task_manager_person_id from pa_tasks pt WHERE pt.task_id = perd.task_id)
1862: AND papf.effective_start_date <= r_effort_report.r_end_date(I)
1863: AND papf.effective_end_date >= r_effort_report.r_start_date(I) AND ROWNUM = 1),
1864: actual_salary_amt = NVL(actual_salary_amt, 0),

Line 1885: SET (employee_number, full_name, mailstop) = (SELECT papf.employee_number, papf.full_name, papf.mailstop FROM per_all_people_f papf

1881: AND perd.investigator_person_id IS NOT NULL;
1882:
1883: FORALL I IN 1..r_effort_report.r_effort_report_id.COUNT
1884: UPDATE psp_eff_reports per
1885: SET (employee_number, full_name, mailstop) = (SELECT papf.employee_number, papf.full_name, papf.mailstop FROM per_all_people_f papf
1886: WHERE papf.person_id = per.person_id AND papf.effective_start_date <= per.end_date
1887: AND papf.effective_end_date >= per.start_date AND ROWNUM = 1),
1888: (emp_primary_org_id, emp_primary_org_name) = (SELECT haou.organization_id, haou.name
1889: FROM hr_all_organization_units haou, per_all_assignments_f paaf

Line 2031: per_all_people_f papf,

2027:
2028: UPDATE psp_report_errors pre
2029: SET (source_name, parent_source_id, parent_source_name) = (SELECT papf.full_name, paaf.organization_id, haou.name
2030: FROM per_all_assignments_f paaf,
2031: per_all_people_f papf,
2032: hr_all_organization_units haou
2033: WHERE haou.organization_id = paaf.organization_id
2034: AND papf.person_id = TO_NUMBER(pre.source_id)
2035: AND paaf.person_id = TO_NUMBER(pre.source_id)

Line 2043: FROM per_all_people_f papf2

2039: WHERE paaf2.effective_start_date <= l_end_date
2040: AND paaf2.effective_end_date >= l_start_date
2041: AND paaf2.person_id = TO_NUMBER(pre.source_id))
2042: AND papf.effective_start_date = (SELECT MAX(papf2.effective_start_date)
2043: FROM per_all_people_f papf2
2044: WHERE papf2.effective_start_date <= l_end_date
2045: AND papf2.effective_end_date >= l_start_date
2046: AND papf2.person_id = TO_NUMBER(pre.source_id)))
2047: WHERE pre.request_id = p_request_id

Line 2053: FROM per_all_people_f papf

2049: AND pre.source_name IS NULL;
2050:
2051: UPDATE psp_report_errors pre
2052: SET source_name = (SELECT papf.full_name
2053: FROM per_all_people_f papf
2054: WHERE papf.person_id = TO_NUMBER(pre.source_id)
2055: AND papf.effective_start_date = (SELECT MAX(papf2.effective_start_date)
2056: FROM per_all_people_f papf2
2057: WHERE papf2.effective_start_date <= l_end_date

Line 2056: FROM per_all_people_f papf2

2052: SET source_name = (SELECT papf.full_name
2053: FROM per_all_people_f papf
2054: WHERE papf.person_id = TO_NUMBER(pre.source_id)
2055: AND papf.effective_start_date = (SELECT MAX(papf2.effective_start_date)
2056: FROM per_all_people_f papf2
2057: WHERE papf2.effective_start_date <= l_end_date
2058: AND papf2.effective_end_date >= l_start_date
2059: AND papf2.person_id = TO_NUMBER(pre.source_id)))
2060: WHERE pre.request_id = p_request_id

Line 2066: FROM per_all_people_f papf

2062: AND pre.source_name IS NULL;
2063:
2064: UPDATE psp_report_errors pre
2065: SET source_name = (SELECT papf.full_name
2066: FROM per_all_people_f papf
2067: WHERE papf.person_id = TO_NUMBER(pre.source_id)
2068: AND papf.effective_start_date = (SELECT MIN(papf2.effective_start_date)
2069: FROM per_all_people_f papf2
2070: WHERE papf2.person_id = TO_NUMBER(pre.source_id)))

Line 2069: FROM per_all_people_f papf2

2065: SET source_name = (SELECT papf.full_name
2066: FROM per_all_people_f papf
2067: WHERE papf.person_id = TO_NUMBER(pre.source_id)
2068: AND papf.effective_start_date = (SELECT MIN(papf2.effective_start_date)
2069: FROM per_all_people_f papf2
2070: WHERE papf2.person_id = TO_NUMBER(pre.source_id)))
2071: WHERE pre.request_id = p_request_id
2072: AND pre.source_id IS NOT NULL
2073: AND pre.source_name IS NULL;