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 HR_ALL_ORGANIZATION_UNITS

Line 210: FROM hr_all_organization_units haou,

206:
207: CURSOR approver_info_cur IS
208: SELECT DISTINCT pera.wf_role_display_name,
209: haou.name
210: FROM hr_all_organization_units haou,
211: psp_eff_report_approvals pera,
212: per_all_assignments_f paaf,
213: fnd_user fu
214: WHERE pera.wf_item_key = p_wf_item_key

Line 1763: exp_org_name = (SELECT name FROM hr_all_organization_units haou

1759: WHERE paa.project_id = perd.project_id),
1760: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1761: WHERE gaa.award_id = perd.award_id),
1762: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug : 16391366
1763: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1764: WHERE haou.organization_id = perd.expenditure_organization_id),
1765: actual_salary_amt = NVL(actual_salary_amt, 0),
1766: payroll_percent = NVL(payroll_percent, 0),
1767: proposed_salary_amt = NVL(proposed_salary_amt, 0),

Line 1822: exp_org_name = (SELECT name FROM hr_all_organization_units haou

1818: WHERE paa.project_id = perd.project_id),
1819: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
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'

Line 1856: exp_org_name = (SELECT name FROM hr_all_organization_units haou

1852: WHERE paa.project_id = perd.project_id),
1853: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
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

Line 1891: exp_org_name = (SELECT name FROM hr_all_organization_units haou

1887: WHERE paa.project_id = perd.project_id),
1888: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
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)

Line 1908: FROM hr_all_organization_units haou, per_all_assignments_f paaf

1904:
1905: FORALL I IN 1..r_effort_report.r_effort_report_id.COUNT
1906: UPDATE psp_eff_report_details perd
1907: SET (investigator_primary_org_id, investigator_org_name) = (SELECT haou.organization_id, haou.name
1908: FROM hr_all_organization_units haou, per_all_assignments_f paaf
1909: WHERE haou.organization_id = paaf.organization_id AND paaf.person_id = perd.investigator_person_id
1910: AND paaf.effective_start_date <= r_effort_report.r_end_date(I)
1911: AND paaf.effective_end_date >= r_effort_report.r_start_date(I)
1912: AND paaf.primary_flag = 'Y' AND ROWNUM = 1)

Line 1926: FROM hr_all_organization_units haou, per_all_assignments_f paaf

1922: AND papf.effective_end_date >= per.start_date
1923: AND papf.employee_number is not NULL -- Bug 8540341
1924: AND ROWNUM = 1),
1925: (emp_primary_org_id, emp_primary_org_name) = (SELECT haou.organization_id, haou.name
1926: FROM hr_all_organization_units haou, per_all_assignments_f paaf
1927: WHERE haou.organization_id = paaf.organization_id AND paaf.person_id = per.person_id
1928: AND paaf.effective_start_date <= per.end_date AND paaf.effective_end_date >= per.start_date
1929: AND paaf.primary_flag = 'Y' AND ROWNUM = 1)
1930: WHERE per.effort_report_id = r_effort_report.r_effort_report_id(I);

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 2033: FROM hr_all_organization_units haou,

2029: FROM
2030: (SELECT rank() over (order by paaf.effective_start_date desc) person_rank,
2031: haou.organization_id,
2032: haou.name
2033: FROM hr_all_organization_units haou,
2034: per_all_assignments_f paaf,
2035: psp_eff_reports per1
2036: WHERE haou.organization_id = paaf.organization_id
2037: AND paaf.person_id = per1.person_id

Line 2191: hr_all_organization_units haou

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
2195: AND paaf.person_id = TO_NUMBER(pre.source_id)