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 GMS_AWARDS_ALL

Line 563: gms_awards_all gaa,

559: INSERT INTO psp_selection_cardinality_gt(lookup_code, total_count)(
560: SELECT 'ATY', COUNT(DISTINCT psl.person_id)
561: FROM psp_summary_lines psl,
562: psp_report_template_details_h prtd ,
563: gms_awards_all gaa,
564: per_time_periods ptp
565: WHERE psl.award_id = gaa.award_id AND
566: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
567: prtd.criteria_lookup_code='ATY' AND

Line 1215: gms_awards_all gaa ,

1211: INSERT INTO psp_selected_persons_t(request_id , person_id, assignment_id)(
1212: SELECT DISTINCT p_request_id, psl.person_id, paf.assignment_id
1213: FROM psp_summary_lines psl,
1214: psp_report_template_details_h prtd ,
1215: gms_awards_all gaa ,
1216: per_time_periods ptp,
1217: per_assignments_f paf
1218: WHERE psl.award_id = gaa.award_id AND
1219: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND

Line 2078: gms_awards_all gaa ,

2074: DELETE FROM psp_selected_persons_t WHERE request_id = p_request_id AND person_id NOT IN (
2075: SELECT NVL(psl.person_id,0)
2076: FROM psp_summary_lines psl,
2077: psp_report_template_details_h prtd ,
2078: gms_awards_all gaa ,
2079: per_time_periods ptp
2080: WHERE psl.award_id = gaa.award_id AND
2081: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2082: prtd.criteria_lookup_code='ATY' AND

Line 2860: gms_awards_all gaa ,

2856: DELETE FROM psp_selected_persons_t WHERE request_id = p_request_id AND person_id IN (
2857: SELECT NVL(psl.person_id,0)
2858: FROM psp_summary_lines psl,
2859: psp_report_template_details_h prtd ,
2860: gms_awards_all gaa ,
2861: per_time_periods ptp
2862: WHERE psl.award_id = gaa.award_id AND
2863: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2864: prtd.criteria_lookup_code='ATY' AND

Line 3750: gms_awards_all gaa,

3746: (lookup_code, total_count)
3747: SELECT 'ATY', COUNT(DISTINCT psl.assignment_id)
3748: FROM psp_summary_lines psl,
3749: psp_report_template_details_h prtd ,
3750: gms_awards_all gaa,
3751: per_time_periods ptp
3752: WHERE psl.award_id = gaa.award_id
3753: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
3754: AND prtd.criteria_lookup_code='ATY'

Line 4311: gms_awards_all gaa,

4307: INSERT INTO psp_selected_persons_t (request_id , person_id, assignment_id)
4308: SELECT DISTINCT p_request_id, psl.person_id, psl.assignment_id
4309: FROM psp_summary_lines psl,
4310: psp_report_template_details_h prtd,
4311: gms_awards_all gaa,
4312: per_time_periods ptp
4313: WHERE psl.award_id = gaa.award_id
4314: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4315: AND prtd.criteria_lookup_code='ATY'

Line 4970: gms_awards_all gaa,

4966: WHERE request_id = p_request_id
4967: AND assignment_id NOT IN (SELECT NVL(psl.assignment_id,0)
4968: FROM psp_summary_lines psl,
4969: psp_report_template_details_h prtd,
4970: gms_awards_all gaa,
4971: per_time_periods ptp
4972: WHERE psl.award_id = gaa.award_id
4973: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4974: AND prtd.criteria_lookup_code='ATY'

Line 5473: gms_awards_all gaa,

5469: WHERE request_id = p_request_id
5470: AND assignment_id IN (SELECT NVL(psl.assignment_id,0)
5471: FROM psp_summary_lines psl,
5472: psp_report_template_details_h prtd,
5473: gms_awards_all gaa,
5474: per_time_periods ptp
5475: WHERE psl.award_id = gaa.award_id
5476: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
5477: AND prtd.criteria_lookup_code='ATY'