[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
2036: delete from psp_selected_persons_t where request_id = p_request_id AND person_id not in (
2037: select psl.person_id
2038: FROM psp_summary_lines psl,
2039: psp_report_template_details_h prtd ,
2040: per_time_periods ptp
2041: WHERE
2042: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2043: prtd.criteria_lookup_code='AWD' AND
2044: prtd.include_exclude_flag='I' AND
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
2083: prtd.include_exclude_flag='I' AND
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
2121: prtd.include_exclude_flag='I' AND
2150: delete from psp_selected_persons_t where request_id = p_request_id AND person_id not in (
2151: select nvl( psl.person_id ,0)
2152: FROM psp_summary_lines psl,
2153: psp_report_template_details_h prtd ,
2154: per_time_periods ptp
2155: WHERE
2156: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2157: prtd.criteria_lookup_code='PRJ' AND
2158: prtd.include_exclude_flag='I' AND
2819: delete from psp_selected_persons_t where request_id = p_request_id AND person_id in (
2820: select psl.person_id
2821: FROM psp_summary_lines psl,
2822: psp_report_template_details_h prtd ,
2823: per_time_periods ptp
2824: WHERE
2825: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2826: prtd.criteria_lookup_code='AWD' AND
2827: prtd.include_exclude_flag='E' AND
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
2865: prtd.include_exclude_flag='E' AND
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
2903: prtd.include_exclude_flag='E' AND
2932: delete from psp_selected_persons_t where request_id = p_request_id AND person_id in (
2933: select nvl( psl.person_id ,0)
2934: FROM psp_summary_lines psl,
2935: psp_report_template_details_h prtd ,
2936: per_time_periods ptp
2937: WHERE
2938: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA' AND
2939: prtd.criteria_lookup_code='PRJ' AND
2940: prtd.include_exclude_flag='E' AND
3708: (lookup_code, total_count)
3709: SELECT 'AWD', COUNT(DISTINCT psl.assignment_id)
3710: FROM psp_summary_lines psl,
3711: psp_report_template_details_h prtd ,
3712: per_time_periods ptp
3713: WHERE
3714: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
3715: AND prtd.criteria_lookup_code='AWD'
3716: AND prtd.include_exclude_flag='I'
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'
3755: AND prtd.include_exclude_flag='I'
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'
3794: AND prtd.include_exclude_flag='I'
3824: (lookup_code, total_count)
3825: SELECT 'PRJ', COUNT(DISTINCT psl.assignment_id)
3826: FROM psp_summary_lines psl,
3827: psp_report_template_details_h prtd ,
3828: per_time_periods ptp
3829: WHERE
3830: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
3831: AND prtd.criteria_lookup_code='PRJ'
3832: AND prtd.include_exclude_flag='I'
4271: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4272: SELECT DISTINCT p_request_id, psl.person_id, psl.assignment_id
4273: FROM psp_summary_lines psl,
4274: psp_report_template_details_h prtd,
4275: per_time_periods ptp
4276: WHERE
4277: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4278: AND prtd.criteria_lookup_code='AWD'
4279: AND prtd.include_exclude_flag='I'
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'
4316: AND prtd.include_exclude_flag='I'
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'
4354: AND prtd.include_exclude_flag='I'
4382: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4383: SELECT DISTINCT p_request_id, psl.person_id, psl.assignment_id
4384: FROM psp_summary_lines psl,
4385: psp_report_template_details_h prtd,
4386: per_time_periods ptp
4387: WHERE
4388: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4389: AND prtd.criteria_lookup_code='PRJ'
4390: AND prtd.include_exclude_flag='I'
4925: WHERE request_id = p_request_id
4926: AND assignment_id NOT IN (SELECT psl.assignment_id
4927: FROM psp_summary_lines psl,
4928: psp_report_template_details_h prtd ,
4929: per_time_periods ptp
4930: WHERE
4931: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
4932: AND prtd.criteria_lookup_code='AWD'
4933: AND prtd.include_exclude_flag='I'
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'
4975: AND prtd.include_exclude_flag='I'
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'
5017: AND prtd.include_exclude_flag='I'
5050: WHERE request_id = p_request_id
5051: AND assignment_id NOT IN (SELECT NVL(psl.assignment_id ,0)
5052: FROM psp_summary_lines psl,
5053: psp_report_template_details_h prtd ,
5054: per_time_periods ptp
5055: WHERE
5056: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
5057: AND prtd.criteria_lookup_code='PRJ'
5058: AND prtd.include_exclude_flag='I'
5431: WHERE request_id = p_request_id
5432: AND assignment_id IN (SELECT psl.assignment_id
5433: FROM psp_summary_lines psl,
5434: psp_report_template_details_h prtd,
5435: per_time_periods ptp
5436: WHERE
5437: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
5438: AND prtd.criteria_lookup_code='AWD'
5439: AND prtd.include_exclude_flag='E'
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'
5478: AND prtd.include_exclude_flag='E'
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'
5517: AND prtd.include_exclude_flag='E'
5547: WHERE request_id = p_request_id
5548: AND assignment_id IN (SELECT NVL(psl.assignment_id,0)
5549: FROM psp_summary_lines psl,
5550: psp_report_template_details_h prtd,
5551: per_time_periods ptp
5552: WHERE
5553: prtd.criteria_lookup_type='PSP_SELECTION_CRITERIA'
5554: AND prtd.criteria_lookup_code='PRJ'
5555: AND prtd.include_exclude_flag='E'