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 PER_ALL_PEOPLE_F

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

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

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

1854: WHERE gaa.award_id = perd.award_id),
1855: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug 16391366
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

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

1889: WHERE gaa.award_id = perd.award_id),
1890: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug 16391366
1891: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1892: WHERE haou.organization_id = perd.expenditure_organization_id),
1893: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1894: WHERE papf.person_id = (select task_manager_person_id from pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id) -- Bug 16391366
1895: AND papf.effective_start_date <= r_effort_report.r_end_date(I)
1896: AND papf.effective_end_date >= r_effort_report.r_start_date(I) AND ROWNUM = 1),
1897: actual_salary_amt = NVL(actual_salary_amt, 0),

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

1916: --Commented the following code for the bug 12326688
1917: /*
1918: FORALL I IN 1..r_effort_report.r_effort_report_id.COUNT
1919: UPDATE psp_eff_reports per
1920: SET (employee_number, full_name, mailstop) = (SELECT papf.employee_number, papf.full_name, papf.mailstop FROM per_all_people_f papf
1921: WHERE papf.person_id = per.person_id AND papf.effective_start_date <= per.end_date
1922: AND papf.effective_end_date >= per.start_date
1923: AND papf.employee_number is not NULL -- Bug 8540341
1924: AND ROWNUM = 1),

Line 1943: from per_all_people_f papf,hr_all_organization_units haou, per_all_assignments_f paaf

1939: UPDATE psp_eff_reports per1
1940: set (employee_number, full_name, mailstop, emp_primary_org_id, emp_primary_org_name ) =
1941: (
1942: select distinct papf.employee_number,papf.full_name,papf.mailstop,haou.organization_id,haou.name
1943: from per_all_people_f papf,hr_all_organization_units haou, per_all_assignments_f paaf
1944: where papf.person_id = per1.person_id
1945: AND papf.effective_start_date <= per1.end_date AND papf.effective_end_date >= per1.start_date
1946: AND per1.end_date between papf.effective_start_date AND papf.effective_end_date
1947: AND papf.employee_number is not NULL

Line 1979: from per_all_people_f papf,hr_all_organization_units haou, per_all_assignments_f paaf

1975: UPDATE psp_eff_reports per1
1976: set (employee_number, full_name, mailstop, emp_primary_org_id, emp_primary_org_name ) =
1977: (
1978: select distinct papf.employee_number,papf.full_name,papf.mailstop,haou.organization_id,haou.name
1979: from per_all_people_f papf,hr_all_organization_units haou, per_all_assignments_f paaf
1980: where papf.person_id = per1.person_id
1981: AND papf.effective_start_date <= per1.end_date AND papf.effective_end_date >= per1.start_date
1982: AND per1.start_date between papf.effective_start_date AND papf.effective_end_date
1983: AND papf.employee_number is not NULL

Line 2017: FROM per_all_people_f papf,

2013: SELECT rank() over (order by papf.effective_start_date desc) person_rank
2014: ,papf.employee_number
2015: ,papf.full_name
2016: ,papf.mailstop
2017: FROM per_all_people_f papf,
2018: psp_eff_reports per1
2019: WHERE papf.person_id = per1.person_id
2020: AND per1.effort_report_id = r_effort_report.r_effort_report_id(I)
2021: AND papf.effective_start_date <= per1.end_date

Line 2190: per_all_people_f papf,

2186:
2187: UPDATE psp_report_errors pre
2188: SET (source_name, parent_source_id, parent_source_name) = (SELECT papf.full_name, paaf.organization_id, haou.name
2189: FROM per_all_assignments_f paaf,
2190: per_all_people_f papf,
2191: hr_all_organization_units haou
2192: WHERE haou.organization_id = paaf.organization_id
2193: AND papf.person_id = TO_NUMBER(pre.source_id)
2194: AND paaf.assignment_type = 'E' -- Added for Bug 10325744

Line 2203: FROM per_all_people_f papf2

2199: WHERE paaf2.effective_start_date <= l_end_date
2200: AND paaf2.effective_end_date >= l_start_date
2201: AND paaf2.person_id = TO_NUMBER(pre.source_id))
2202: AND papf.effective_start_date = (SELECT MAX(papf2.effective_start_date)
2203: FROM per_all_people_f papf2
2204: WHERE papf2.effective_start_date <= l_end_date
2205: AND papf2.effective_end_date >= l_start_date
2206: AND papf2.person_id = TO_NUMBER(pre.source_id)))
2207: WHERE pre.request_id = p_request_id

Line 2213: FROM per_all_people_f papf

2209: AND pre.source_name IS NULL;
2210:
2211: UPDATE psp_report_errors pre
2212: SET source_name = (SELECT papf.full_name
2213: FROM per_all_people_f papf
2214: WHERE papf.person_id = TO_NUMBER(pre.source_id)
2215: AND papf.effective_start_date = (SELECT MAX(papf2.effective_start_date)
2216: FROM per_all_people_f papf2
2217: WHERE papf2.effective_start_date <= l_end_date

Line 2216: FROM per_all_people_f papf2

2212: SET source_name = (SELECT papf.full_name
2213: FROM per_all_people_f papf
2214: WHERE papf.person_id = TO_NUMBER(pre.source_id)
2215: AND papf.effective_start_date = (SELECT MAX(papf2.effective_start_date)
2216: FROM per_all_people_f papf2
2217: WHERE papf2.effective_start_date <= l_end_date
2218: AND papf2.effective_end_date >= l_start_date
2219: AND papf2.person_id = TO_NUMBER(pre.source_id)))
2220: WHERE pre.request_id = p_request_id

Line 2226: FROM per_all_people_f papf

2222: AND pre.source_name IS NULL;
2223:
2224: UPDATE psp_report_errors pre
2225: SET source_name = (SELECT papf.full_name
2226: FROM per_all_people_f papf
2227: WHERE papf.person_id = TO_NUMBER(pre.source_id)
2228: AND papf.effective_start_date = (SELECT MIN(papf2.effective_start_date)
2229: FROM per_all_people_f papf2
2230: WHERE papf2.person_id = TO_NUMBER(pre.source_id)))

Line 2229: FROM per_all_people_f papf2

2225: SET source_name = (SELECT papf.full_name
2226: FROM per_all_people_f papf
2227: WHERE papf.person_id = TO_NUMBER(pre.source_id)
2228: AND papf.effective_start_date = (SELECT MIN(papf2.effective_start_date)
2229: FROM per_all_people_f papf2
2230: WHERE papf2.person_id = TO_NUMBER(pre.source_id)))
2231: WHERE pre.request_id = p_request_id
2232: AND pre.source_id IS NOT NULL
2233: AND pre.source_name IS NULL;