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 PA_PROJECTS_ALL

Line 890: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type = ppa.project_type AND '

886: || 'TRIM(TO_CHAR(SUM(NVL(pera.actual_cost_share, 0)), ''999G990D00'')) total_spon_actual_cost_share '
887: || 'FROM psp_eff_report_details perd, psp_eff_report_approvals pera '
888: || 'WHERE (perd.project_id IS NOT NULL OR perd.task_id IS NOT NULL OR perd.award_id '
889: || 'IS NOT NULL OR perd.expenditure_organization_id IS NOT NULL OR perd.expenditure_type IS NOT NULL) AND EXISTS '
890: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type = ppa.project_type AND '
891: || 'ppa.project_id = perd.project_id AND ppa.project_type <> ''AWARD_PROJECT'' AND NVL(gpta.sponsored_flag, ''N'') ='
892: || '''Y'') AND perd.effort_report_detail_id = pera.effort_report_detail_id (+) AND effort_report_id = '
893: || TO_CHAR(p_effort_report_id) || ' AND NVL(pera.approval_status, ''A'') IN (''P'', ''A'')' || l_assignment_check;
894: qryCtx1 := dbms_xmlgen.newContext(query1);

Line 912: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type (+) = ppa.project_type AND '

908: || 'TRIM(TO_CHAR(SUM(NVL(pera.actual_cost_share, 0)), ''999G990D00'')) total_nspon_actual_cost_share '
909: || 'FROM psp_eff_report_details perd, psp_eff_report_approvals pera '
910: || 'WHERE (perd.project_id IS NOT NULL OR perd.task_id IS NOT NULL OR perd.award_id '
911: || 'IS NOT NULL OR perd.expenditure_organization_id IS NOT NULL OR perd.expenditure_type IS NOT NULL) AND EXISTS '
912: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type (+) = ppa.project_type AND '
913: || 'ppa.project_id = perd.project_id AND ppa.project_type <> ''AWARD_PROJECT'' AND NVL(gpta.sponsored_flag, ''N'') ='
914: || '''N'') AND perd.effort_report_detail_id = pera.effort_report_detail_id (+) AND effort_report_id = '
915: || TO_CHAR(p_effort_report_id) || ' AND NVL(pera.approval_status, ''A'') IN (''P'', ''A'')' || l_assignment_check;
916: qryCtx1 := dbms_xmlgen.newContext(query1);

Line 963: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type = ppa.project_type AND '

959: || 'perd.*, TRIM(TO_CHAR(NVL(pera.overwritten_effort_percent, 0), ''999G990D00'')) overwritten_effort_percent, '
960: || 'TRIM(TO_CHAR(NVL(pera.actual_cost_share, 0), ''999G990D00'')) actual_cost_share FROM psp_eff_report_details perd, '
961: || 'psp_eff_report_approvals pera WHERE (perd.project_id IS NOT NULL OR perd.task_id IS NOT NULL OR perd.award_id '
962: || 'IS NOT NULL OR perd.expenditure_organization_id IS NOT NULL OR perd.expenditure_type IS NOT NULL) AND EXISTS '
963: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type = ppa.project_type AND '
964: || 'ppa.project_id = perd.project_id AND ppa.project_type <> ''AWARD_PROJECT'' AND NVL(gpta.sponsored_flag, ''N'') ='
965: || '''Y'') AND perd.effort_report_detail_id = pera.effort_report_detail_id (+) AND effort_report_id = '
966: || TO_CHAR(p_effort_report_id) || ' AND NVL(pera.approval_status, ''A'') IN (''P'', ''A'')' || l_assignment_check || l_sort_option1;
967: qryCtx1 := dbms_xmlgen.newContext(query1);

Line 988: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type(+) = ppa.project_type AND '

984: || 'perd.*, TRIM(TO_CHAR(NVL(pera.overwritten_effort_percent, 0), ''999G990D00'')) overwritten_effort_percent, '
985: || 'TRIM(TO_CHAR(NVL(pera.actual_cost_share, 0), ''999G990D00'')) actual_cost_share FROM psp_eff_report_details perd, '
986: || 'psp_eff_report_approvals pera WHERE (perd.project_id IS NOT NULL OR perd.task_id IS NOT NULL OR perd.award_id '
987: || 'IS NOT NULL OR perd.expenditure_organization_id IS NOT NULL OR perd.expenditure_type IS NOT NULL) AND EXISTS '
988: || '(SELECT 1 FROM pa_projects_all ppa, gms_project_types_all gpta WHERE gpta.project_type(+) = ppa.project_type AND '
989: || 'ppa.project_id = perd.project_id AND ppa.project_type <> ''AWARD_PROJECT'' AND NVL(gpta.sponsored_flag, ''N'') ='
990: || '''N'') AND perd.effort_report_detail_id = pera.effort_report_detail_id (+) AND effort_report_id = '
991: || TO_CHAR(p_effort_report_id) || ' AND NVL(pera.approval_status, ''A'') IN (''P'', ''A'')' || l_assignment_check || l_sort_option1;
992: qryCtx1 := dbms_xmlgen.newContext(query1);

Line 1758: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa

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
1757: AND ROWNUM = 1),
1758: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
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

Line 1817: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa

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
1816: AND ROWNUM = 1),
1817: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
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

Line 1851: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa

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
1850: AND ROWNUM = 1),
1851: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
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

Line 1886: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa

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
1885: AND ROWNUM = 1),
1886: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
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

Line 2302: AND EXISTS (SELECT 1 FROM pa_projects_all ppa, gms_project_types gpta -- Changed from gms_project_types_all for bug 5503605

2298: AND request_id = p_request_id
2299: AND ( perd.project_id IS NOT NULL OR perd.task_id IS NOT NULL
2300: OR perd.award_id IS NOT NULL OR perd.expenditure_organization_id IS NOT NULL
2301: OR perd.expenditure_type IS NOT NULL)
2302: AND EXISTS (SELECT 1 FROM pa_projects_all ppa, gms_project_types gpta -- Changed from gms_project_types_all for bug 5503605
2303: WHERE gpta.project_type = ppa.project_type
2304: AND ppa.project_id = perd.project_id
2305: AND ppa.project_type <> 'AWARD_PROJECT' AND NVL(gpta.sponsored_flag, 'N') ='Y');
2306:

Line 2317: AND EXISTS (SELECT 1 FROM pa_projects_all ppa, gms_project_types gpta -- Changed from gms_project_types_all for bug 5503605

2313: AND request_id = p_request_id
2314: AND ( perd.project_id IS NOT NULL OR perd.task_id IS NOT NULL
2315: OR perd.award_id IS NOT NULL OR perd.expenditure_organization_id IS NOT NULL
2316: OR perd.expenditure_type IS NOT NULL)
2317: AND EXISTS (SELECT 1 FROM pa_projects_all ppa, gms_project_types gpta -- Changed from gms_project_types_all for bug 5503605
2318: WHERE gpta.project_type(+) = ppa.project_type
2319: AND ppa.project_id = perd.project_id
2320: AND ppa.project_type <> 'AWARD_PROJECT' AND NVL(gpta.sponsored_flag, 'N') ='N');
2321: