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 2045: gms_awards_all gaa ,

2041: DELETE FROM psp_selected_persons_t WHERE request_id = p_request_id AND person_id NOT IN (
2042: SELECT NVL(psl.person_id,0)
2043: FROM psp_summary_lines psl,
2044: psp_report_template_details_h prtd ,
2045: gms_awards_all gaa ,
2046: per_time_periods ptp
2047: WHERE psl.award_id = gaa.award_id AND
2048: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2049: prtd.criteria_lookup_code='ATY' AND

Line 2827: gms_awards_all gaa ,

2823: DELETE FROM psp_selected_persons_t WHERE request_id = p_request_id AND person_id IN (
2824: SELECT NVL(psl.person_id,0)
2825: FROM psp_summary_lines psl,
2826: psp_report_template_details_h prtd ,
2827: gms_awards_all gaa ,
2828: per_time_periods ptp
2829: WHERE psl.award_id = gaa.award_id AND
2830: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2831: prtd.criteria_lookup_code='ATY' AND

Line 3717: gms_awards_all gaa,

3713: (lookup_code, total_count)
3714: SELECT 'ATY', COUNT(DISTINCT psl.assignment_id)
3715: FROM psp_summary_lines psl,
3716: psp_report_template_details_h prtd ,
3717: gms_awards_all gaa,
3718: per_time_periods ptp
3719: WHERE psl.award_id = gaa.award_id
3720: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
3721: AND prtd.criteria_lookup_code='ATY'

Line 4278: gms_awards_all gaa,

4274: INSERT INTO psp_selected_persons_t (request_id , person_id, assignment_id)
4275: SELECT DISTINCT p_request_id, psl.person_id, psl.assignment_id
4276: FROM psp_summary_lines psl,
4277: psp_report_template_details_h prtd,
4278: gms_awards_all gaa,
4279: per_time_periods ptp
4280: WHERE psl.award_id = gaa.award_id
4281: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4282: AND prtd.criteria_lookup_code='ATY'

Line 4937: gms_awards_all gaa,

4933: WHERE request_id = p_request_id
4934: AND assignment_id NOT IN (SELECT NVL(psl.assignment_id,0)
4935: FROM psp_summary_lines psl,
4936: psp_report_template_details_h prtd,
4937: gms_awards_all gaa,
4938: per_time_periods ptp
4939: WHERE psl.award_id = gaa.award_id
4940: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4941: AND prtd.criteria_lookup_code='ATY'

Line 5440: gms_awards_all gaa,

5436: WHERE request_id = p_request_id
5437: AND assignment_id IN (SELECT NVL(psl.assignment_id,0)
5438: FROM psp_summary_lines psl,
5439: psp_report_template_details_h prtd,
5440: gms_awards_all gaa,
5441: per_time_periods ptp
5442: WHERE psl.award_id = gaa.award_id
5443: AND prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
5444: AND prtd.criteria_lookup_code='ATY'