[Home] [Help]
521: insert into psp_selection_cardinality_gt(lookup_code, total_count)(
522: SELECT 'AWD', COUNT(DISTINCT psl.person_id)
523: FROM psp_summary_lines psl,
524: psp_report_template_details_h prtd ,
525: per_time_periods ptp
526: WHERE
527: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
528: prtd.criteria_lookup_code='AWD' AND
529: prtd.include_exclude_flag='I' AND
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
568: prtd.include_exclude_flag='I' AND
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
605: prtd.include_exclude_flag='I' AND
633: insert into psp_selection_cardinality_gt(lookup_code, total_count)(
634: SELECT 'PRJ', COUNT(DISTINCT psl.person_id)
635: FROM psp_summary_lines psl,
636: psp_report_template_details_h prtd ,
637: per_time_periods ptp
638: WHERE
639: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
640: prtd.criteria_lookup_code='PRJ' AND
641: prtd.include_exclude_flag='I' AND
1169: insert into psp_selected_persons_t(request_id, person_id, assignment_id)(
1170: select distinct p_request_id, psl.person_id , paf.assignment_id
1171: FROM psp_summary_lines psl,
1172: psp_report_template_details_h prtd ,
1173: per_time_periods ptp,
1174: per_assignments_f paf
1175: WHERE
1176: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
1177: prtd.criteria_lookup_code='AWD' AND
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
1220: prtd.criteria_lookup_code='ATY' AND
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
1263: prtd.criteria_lookup_code='PRT' AND
1302: insert into psp_selected_persons_t(request_id, person_id, assignment_id)(
1303: select distinct p_request_id, psl.person_id, paf.assignment_id
1304: FROM psp_summary_lines psl,
1305: psp_report_template_details_h prtd ,
1306: per_time_periods ptp,
1307: per_assignments_f paf
1308: WHERE
1309: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
1310: prtd.criteria_lookup_code='PRJ' AND
2003: delete from psp_selected_persons_t where request_id = p_request_id AND person_id not in (
2004: select psl.person_id
2005: FROM psp_summary_lines psl,
2006: psp_report_template_details_h prtd ,
2007: per_time_periods ptp
2008: WHERE
2009: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2010: prtd.criteria_lookup_code='AWD' AND
2011: prtd.include_exclude_flag='I' AND
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
2050: prtd.include_exclude_flag='I' AND
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
2088: prtd.include_exclude_flag='I' AND
2117: delete from psp_selected_persons_t where request_id = p_request_id AND person_id not in (
2118: select nvl( psl.person_id ,0)
2119: FROM psp_summary_lines psl,
2120: psp_report_template_details_h prtd ,
2121: per_time_periods ptp
2122: WHERE
2123: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2124: prtd.criteria_lookup_code='PRJ' AND
2125: prtd.include_exclude_flag='I' AND
2786: delete from psp_selected_persons_t where request_id = p_request_id AND person_id in (
2787: select psl.person_id
2788: FROM psp_summary_lines psl,
2789: psp_report_template_details_h prtd ,
2790: per_time_periods ptp
2791: WHERE
2792: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2793: prtd.criteria_lookup_code='AWD' AND
2794: prtd.include_exclude_flag='E' AND
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
2832: prtd.include_exclude_flag='E' AND
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
2870: prtd.include_exclude_flag='E' AND
2899: delete from psp_selected_persons_t where request_id = p_request_id AND person_id in (
2900: select nvl( psl.person_id ,0)
2901: FROM psp_summary_lines psl,
2902: psp_report_template_details_h prtd ,
2903: per_time_periods ptp
2904: WHERE
2905: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2906: prtd.criteria_lookup_code='PRJ' AND
2907: prtd.include_exclude_flag='E' AND
3675: (lookup_code, total_count)
3676: SELECT 'AWD', COUNT(DISTINCT psl.assignment_id)
3677: FROM psp_summary_lines psl,
3678: psp_report_template_details_h prtd ,
3679: per_time_periods ptp
3680: WHERE
3681: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
3682: AND prtd.criteria_lookup_code='AWD'
3683: AND prtd.include_exclude_flag='I'
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'
3722: AND prtd.include_exclude_flag='I'
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'
3761: AND prtd.include_exclude_flag='I'
3791: (lookup_code, total_count)
3792: SELECT 'PRJ', COUNT(DISTINCT psl.assignment_id)
3793: FROM psp_summary_lines psl,
3794: psp_report_template_details_h prtd ,
3795: per_time_periods ptp
3796: WHERE
3797: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
3798: AND prtd.criteria_lookup_code='PRJ'
3799: AND prtd.include_exclude_flag='I'
4238: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4239: SELECT DISTINCT p_request_id, psl.person_id, psl.assignment_id
4240: FROM psp_summary_lines psl,
4241: psp_report_template_details_h prtd,
4242: per_time_periods ptp
4243: WHERE
4244: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4245: AND prtd.criteria_lookup_code='AWD'
4246: AND prtd.include_exclude_flag='I'
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'
4283: AND prtd.include_exclude_flag='I'
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'
4321: AND prtd.include_exclude_flag='I'
4349: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4350: SELECT DISTINCT p_request_id, psl.person_id, psl.assignment_id
4351: FROM psp_summary_lines psl,
4352: psp_report_template_details_h prtd,
4353: per_time_periods ptp
4354: WHERE
4355: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4356: AND prtd.criteria_lookup_code='PRJ'
4357: AND prtd.include_exclude_flag='I'
4892: WHERE request_id = p_request_id
4893: AND assignment_id NOT IN (SELECT psl.assignment_id
4894: FROM psp_summary_lines psl,
4895: psp_report_template_details_h prtd ,
4896: per_time_periods ptp
4897: WHERE
4898: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4899: AND prtd.criteria_lookup_code='AWD'
4900: AND prtd.include_exclude_flag='I'
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'
4942: AND prtd.include_exclude_flag='I'
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'
4984: AND prtd.include_exclude_flag='I'
5017: WHERE request_id = p_request_id
5018: AND assignment_id NOT IN (SELECT NVL(psl.assignment_id ,0)
5019: FROM psp_summary_lines psl,
5020: psp_report_template_details_h prtd ,
5021: per_time_periods ptp
5022: WHERE
5023: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
5024: AND prtd.criteria_lookup_code='PRJ'
5025: AND prtd.include_exclude_flag='I'
5398: WHERE request_id = p_request_id
5399: AND assignment_id IN (SELECT psl.assignment_id
5400: FROM psp_summary_lines psl,
5401: psp_report_template_details_h prtd,
5402: per_time_periods ptp
5403: WHERE
5404: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
5405: AND prtd.criteria_lookup_code='AWD'
5406: AND prtd.include_exclude_flag='E'
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'
5445: AND prtd.include_exclude_flag='E'
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'
5484: AND prtd.include_exclude_flag='E'
5514: WHERE request_id = p_request_id
5515: AND assignment_id IN (SELECT NVL(psl.assignment_id,0)
5516: FROM psp_summary_lines psl,
5517: psp_report_template_details_h prtd,
5518: per_time_periods ptp
5519: WHERE
5520: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
5521: AND prtd.criteria_lookup_code='PRJ'
5522: AND prtd.include_exclude_flag='E'