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

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

Line 1736: exp_org_name = (SELECT name FROM hr_all_organization_units haou

1732: WHERE paa.project_id = perd.project_id),
1733: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1734: WHERE gaa.award_id = perd.award_id),
1735: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),
1736: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1737: WHERE haou.organization_id = perd.expenditure_organization_id),
1738: actual_salary_amt = NVL(actual_salary_amt, 0),
1739: payroll_percent = NVL(payroll_percent, 0),
1740: proposed_salary_amt = NVL(proposed_salary_amt, 0),

Line 1793: exp_org_name = (SELECT name FROM hr_all_organization_units haou

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

Line 1825: exp_org_name = (SELECT name FROM hr_all_organization_units haou

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

Line 1858: exp_org_name = (SELECT name FROM hr_all_organization_units haou

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

Line 1875: FROM hr_all_organization_units haou, per_all_assignments_f paaf

1871:
1872: FORALL I IN 1..r_effort_report.r_effort_report_id.COUNT
1873: UPDATE psp_eff_report_details perd
1874: SET (investigator_primary_org_id, investigator_org_name) = (SELECT haou.organization_id, haou.name
1875: FROM hr_all_organization_units haou, per_all_assignments_f paaf
1876: WHERE haou.organization_id = paaf.organization_id AND paaf.person_id = perd.investigator_person_id
1877: AND paaf.effective_start_date <= r_effort_report.r_end_date(I)
1878: AND paaf.effective_end_date >= r_effort_report.r_start_date(I)
1879: AND paaf.primary_flag = 'Y' AND ROWNUM = 1)

Line 1889: FROM hr_all_organization_units haou, per_all_assignments_f paaf

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
1890: WHERE haou.organization_id = paaf.organization_id AND paaf.person_id = per.person_id
1891: AND paaf.effective_start_date <= per.end_date AND paaf.effective_end_date >= per.start_date
1892: AND paaf.primary_flag = 'Y' AND ROWNUM = 1)
1893: WHERE per.effort_report_id = r_effort_report.r_effort_report_id(I);

Line 2032: hr_all_organization_units haou

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)
2036: AND paaf.primary_flag = 'Y'