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_TEMPLATE_SELECTION dependencies on PA_PROJECTS_ALL

Line 600: pa_projects_all ppa ,

596: INSERT INTO psp_selection_cardinality_gt(lookup_code, total_count)(
597: SELECT 'PRT', COUNT(DISTINCT psl.person_id)
598: FROM psp_summary_lines psl,
599: psp_report_template_details_h prtd ,
600: pa_projects_all ppa ,
601: per_time_periods ptp
602: WHERE psl.project_id = ppa.project_id AND
603: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
604: prtd.criteria_lookup_code='PRT' AND

Line 1258: pa_projects_all ppa ,

1254: INSERT INTO psp_selected_persons_t(request_id , person_id, assignment_id)(
1255: SELECT DISTINCT p_request_id, psl.person_id, paf.assignment_id
1256: FROM psp_summary_lines psl,
1257: psp_report_template_details_h prtd ,
1258: pa_projects_all ppa ,
1259: per_time_periods ptp,
1260: per_assignments_f paf
1261: WHERE psl.project_id = ppa.project_id AND
1262: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND

Line 2083: pa_projects_all ppa ,

2079: DELETE FROM psp_selected_persons_t WHERE request_id = p_request_id AND person_id NOT IN (
2080: SELECT NVL(psl.person_id,0)
2081: FROM psp_summary_lines psl,
2082: psp_report_template_details_h prtd ,
2083: pa_projects_all ppa ,
2084: per_time_periods ptp
2085: WHERE psl.project_id = ppa.project_id AND
2086: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2087: prtd.criteria_lookup_code='PRT' AND

Line 2865: pa_projects_all ppa ,

2861: DELETE FROM psp_selected_persons_t WHERE request_id = p_request_id AND person_id IN (
2862: SELECT NVL(psl.person_id,0)
2863: FROM psp_summary_lines psl,
2864: psp_report_template_details_h prtd ,
2865: pa_projects_all ppa ,
2866: per_time_periods ptp
2867: WHERE psl.project_id = ppa.project_id AND
2868: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2869: prtd.criteria_lookup_code='PRT' AND

Line 3756: pa_projects_all ppa ,

3752: (lookup_code, total_count)
3753: SELECT 'PRT', COUNT(DISTINCT psl.assignment_id)
3754: FROM psp_summary_lines psl,
3755: psp_report_template_details_h prtd ,
3756: pa_projects_all ppa ,
3757: per_time_periods ptp
3758: WHERE psl.project_id = ppa.project_id
3759: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
3760: AND prtd.criteria_lookup_code='PRT'

Line 4316: pa_projects_all ppa,

4312: INSERT INTO psp_selected_persons_t (request_id , person_id, assignment_id)
4313: SELECT DISTINCT p_request_id, psl.person_id, psl.assignment_id
4314: FROM psp_summary_lines psl,
4315: psp_report_template_details_h prtd,
4316: pa_projects_all ppa,
4317: per_time_periods ptp
4318: WHERE psl.project_id = ppa.project_id
4319: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4320: AND prtd.criteria_lookup_code='PRT'

Line 4979: pa_projects_all ppa,

4975: WHERE request_id = p_request_id
4976: AND assignment_id NOT IN (SELECT NVL(psl.assignment_id,0)
4977: FROM psp_summary_lines psl,
4978: psp_report_template_details_h prtd,
4979: pa_projects_all ppa,
4980: per_time_periods ptp
4981: WHERE psl.project_id = ppa.project_id
4982: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4983: AND prtd.criteria_lookup_code='PRT'

Line 5479: pa_projects_all ppa,

5475: WHERE request_id = p_request_id
5476: AND assignment_id IN (SELECT NVL(psl.assignment_id,0)
5477: FROM psp_summary_lines psl,
5478: psp_report_template_details_h prtd,
5479: pa_projects_all ppa,
5480: per_time_periods ptp
5481: WHERE psl.project_id = ppa.project_id
5482: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
5483: AND prtd.criteria_lookup_code='PRT'