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_ASSIGNMENTS_F

Line 212: per_all_assignments_f paaf,

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
215: AND fu.employee_id = paaf.person_id
216: AND fu.user_name = pera.wf_role_name

Line 1752: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per

1748:
1749: IF (l_layout_type = 'EMP') THEN
1750: FORALL I IN 1..r_effort_report.r_effort_report_id.COUNT
1751: UPDATE psp_eff_report_details perd
1752: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per
1753: WHERE per.effort_report_id = perd.effort_report_id AND paaf.assignment_id = perd.assignment_id
1754: AND paaf.effective_start_date <= r_effort_report.r_end_date(I)
1755: AND paaf.effective_end_date >= r_effort_report.r_start_date(I)
1756: AND paaf.assignment_number is not null -- Bug 8540341

Line 1811: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per

1807: END IF;
1808: ELSIF (l_layout_type = 'PIV') THEN
1809: FORALL I IN 1..r_effort_report.r_effort_report_id.COUNT
1810: UPDATE psp_eff_report_details perd
1811: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per
1812: WHERE per.effort_report_id = perd.effort_report_id AND paaf.assignment_id = perd.assignment_id
1813: AND paaf.effective_start_date <= r_effort_report.r_end_date(I)
1814: AND paaf.effective_end_date >= r_effort_report.r_start_date(I)
1815: AND paaf.assignment_number is not null -- Bug 8540341

Line 1845: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per

1841: WHERE perd.effort_report_id = r_effort_report.r_effort_report_id(I);
1842: ELSIF (l_layout_type = 'PMG') THEN
1843: FORALL I IN 1..r_effort_report.r_effort_report_id.COUNT
1844: UPDATE psp_eff_report_details perd
1845: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per
1846: WHERE per.effort_report_id = perd.effort_report_id AND paaf.assignment_id = perd.assignment_id
1847: AND paaf.effective_start_date <= r_effort_report.r_end_date(I)
1848: AND paaf.effective_end_date >= r_effort_report.r_start_date(I)
1849: AND paaf.assignment_number is not null -- Bug 8540341

Line 1880: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per

1876: WHERE perd.effort_report_id = r_effort_report.r_effort_report_id(I);
1877: ELSIF (l_layout_type = 'TMG') THEN
1878: FORALL I IN 1..r_effort_report.r_effort_report_id.COUNT
1879: UPDATE psp_eff_report_details perd
1880: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per
1881: WHERE per.effort_report_id = perd.effort_report_id AND paaf.assignment_id = perd.assignment_id
1882: AND paaf.effective_start_date <= per.end_date
1883: AND paaf.effective_end_date >= per.start_date
1884: AND paaf.assignment_number is not null -- Bug 8540341

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 2034: per_all_assignments_f paaf,

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
2038: AND per1.effort_report_id = r_effort_report.r_effort_report_id(I)

Line 2189: FROM per_all_assignments_f paaf,

2185: AND pre.source_name IS NULL;
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)

Line 2198: FROM per_all_assignments_f paaf2

2194: AND paaf.assignment_type = 'E' -- Added for Bug 10325744
2195: AND paaf.person_id = TO_NUMBER(pre.source_id)
2196: AND paaf.primary_flag = 'Y'
2197: AND paaf.effective_start_date = (SELECT MAX(paaf2.effective_start_date)
2198: FROM per_all_assignments_f paaf2
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)