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

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

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

1723:
1724: IF (l_layout_type = 'EMP') THEN
1725: FORALL I IN 1..r_effort_report.r_effort_report_id.COUNT
1726: UPDATE psp_eff_report_details perd
1727: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per
1728: WHERE per.effort_report_id = perd.effort_report_id AND paaf.assignment_id = perd.assignment_id
1729: AND paaf.effective_start_date <= r_effort_report.r_end_date(I)
1730: AND paaf.effective_end_date >= r_effort_report.r_start_date(I) AND ROWNUM = 1),
1731: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa

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

1780: END IF;
1781: ELSIF (l_layout_type = 'PIV') THEN
1782: FORALL I IN 1..r_effort_report.r_effort_report_id.COUNT
1783: UPDATE psp_eff_report_details perd
1784: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per
1785: WHERE per.effort_report_id = perd.effort_report_id AND paaf.assignment_id = perd.assignment_id
1786: AND paaf.effective_start_date <= r_effort_report.r_end_date(I)
1787: AND paaf.effective_end_date >= r_effort_report.r_start_date(I) AND ROWNUM = 1),
1788: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa

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

1812: WHERE perd.effort_report_id = r_effort_report.r_effort_report_id(I);
1813: ELSIF (l_layout_type = 'PMG') THEN
1814: FORALL I IN 1..r_effort_report.r_effort_report_id.COUNT
1815: UPDATE psp_eff_report_details perd
1816: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per
1817: WHERE per.effort_report_id = perd.effort_report_id AND paaf.assignment_id = perd.assignment_id
1818: AND paaf.effective_start_date <= r_effort_report.r_end_date(I)
1819: AND paaf.effective_end_date >= r_effort_report.r_start_date(I) AND ROWNUM = 1),
1820: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa

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

1845: WHERE perd.effort_report_id = r_effort_report.r_effort_report_id(I);
1846: ELSIF (l_layout_type = 'TMG') THEN
1847: FORALL I IN 1..r_effort_report.r_effort_report_id.COUNT
1848: UPDATE psp_eff_report_details perd
1849: SET assignment_number = (SELECT assignment_number FROM per_all_assignments_f paaf, psp_eff_reports per
1850: WHERE per.effort_report_id = perd.effort_report_id AND paaf.assignment_id = perd.assignment_id
1851: AND paaf.effective_start_date <= per.end_date
1852: AND paaf.effective_end_date >= per.start_date AND ROWNUM = 1),
1853: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa

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

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

Line 2038: FROM per_all_assignments_f paaf2

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'
2037: AND paaf.effective_start_date = (SELECT MAX(paaf2.effective_start_date)
2038: FROM per_all_assignments_f paaf2
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)