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 GMS_AWARDS_ALL

Line 1733: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa

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
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),

Line 1790: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa

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
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),

Line 1822: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa

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
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),

Line 1855: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa

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
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),