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 2116: pa_projects_all ppa ,

2112: DELETE FROM psp_selected_persons_t WHERE request_id = p_request_id AND person_id NOT IN (
2113: SELECT NVL(psl.person_id,0)
2114: FROM psp_summary_lines psl,
2115: psp_report_template_details_h prtd ,
2116: pa_projects_all ppa ,
2117: per_time_periods ptp
2118: WHERE psl.project_id = ppa.project_id AND
2119: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2120: prtd.criteria_lookup_code='PRT' AND

Line 2898: pa_projects_all ppa ,

2894: DELETE FROM psp_selected_persons_t WHERE request_id = p_request_id AND person_id IN (
2895: SELECT NVL(psl.person_id,0)
2896: FROM psp_summary_lines psl,
2897: psp_report_template_details_h prtd ,
2898: pa_projects_all ppa ,
2899: per_time_periods ptp
2900: WHERE psl.project_id = ppa.project_id AND
2901: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2902: prtd.criteria_lookup_code='PRT' AND

Line 3789: pa_projects_all ppa ,

3785: (lookup_code, total_count)
3786: SELECT 'PRT', COUNT(DISTINCT psl.assignment_id)
3787: FROM psp_summary_lines psl,
3788: psp_report_template_details_h prtd ,
3789: pa_projects_all ppa ,
3790: per_time_periods ptp
3791: WHERE psl.project_id = ppa.project_id
3792: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
3793: AND prtd.criteria_lookup_code='PRT'

Line 4349: pa_projects_all ppa,

4345: INSERT INTO psp_selected_persons_t (request_id , person_id, assignment_id)
4346: SELECT DISTINCT p_request_id, psl.person_id, psl.assignment_id
4347: FROM psp_summary_lines psl,
4348: psp_report_template_details_h prtd,
4349: pa_projects_all ppa,
4350: per_time_periods ptp
4351: WHERE psl.project_id = ppa.project_id
4352: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4353: AND prtd.criteria_lookup_code='PRT'

Line 5012: pa_projects_all ppa,

5008: WHERE request_id = p_request_id
5009: AND assignment_id NOT IN (SELECT NVL(psl.assignment_id,0)
5010: FROM psp_summary_lines psl,
5011: psp_report_template_details_h prtd,
5012: pa_projects_all ppa,
5013: per_time_periods ptp
5014: WHERE psl.project_id = ppa.project_id
5015: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
5016: AND prtd.criteria_lookup_code='PRT'

Line 5512: pa_projects_all ppa,

5508: WHERE request_id = p_request_id
5509: AND assignment_id IN (SELECT NVL(psl.assignment_id,0)
5510: FROM psp_summary_lines psl,
5511: psp_report_template_details_h prtd,
5512: pa_projects_all ppa,
5513: per_time_periods ptp
5514: WHERE psl.project_id = ppa.project_id
5515: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
5516: AND prtd.criteria_lookup_code='PRT'