[Home] [Help]
765:
766: ELSIF template_rec.array_sel_criteria(i) = 'AST' THEN
767:
768: insert into psp_selection_cardinality_gt(lookup_code, total_count) (
769: select 'AST', count(distinct paf.person_id) from per_all_assignments_f paf, hr_assignment_sets has ,
770: hr_assignment_Set_amendments hasa
771: where
772: has.assignment_set_id in (
773: select TO_NUMBER(criteria_value1) from psp_report_template_details_h
1494:
1495: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
1496: SELECT DISTINCT p_request_id, paf.person_id, paf.assignment_id
1497: FROM per_all_assignments_f paf,
1498: hr_assignment_sets has,
1499: hr_assignment_set_amendments hasa,
1500: per_all_people_f ppf,
1501: per_assignment_status_types past
1502: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
2307: DELETE FROM psp_selected_persons_t
2308: WHERE request_id = p_request_id
2309: AND person_id NOT IN (SELECT NVL(paf.person_id,0)
2310: FROM per_all_assignments_f paf,
2311: hr_assignment_sets has,
2312: hr_assignment_set_amendments hasa,
2313: per_assignment_status_types past
2314: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
2315: FROM psp_report_template_details_h prtd
3189: DELETE FROM psp_selected_persons_t
3190: WHERE request_id = p_request_id
3191: AND person_id IN (SELECT NVL(paf.person_id,0)
3192: FROM per_all_assignments_f paf,
3193: hr_assignment_sets has,
3194: hr_assignment_set_amendments hasa,
3195: per_assignment_status_types past
3196: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
3197: FROM psp_report_template_details_h prtd
3926: INSERT INTO psp_selection_cardinality_gt
3927: (lookup_code, total_count)
3928: SELECT 'AST', COUNT(DISTINCT paf.assignment_id)
3929: FROM per_all_assignments_f paf,
3930: hr_assignment_sets has ,
3931: hr_assignment_set_amendments hasa
3932: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
3933: FROM psp_report_template_details_h prtd
3934: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
4519:
4520: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4521: SELECT DISTINCT p_request_id, person_id, paf.assignment_id
4522: FROM per_all_assignments_f paf,
4523: hr_assignment_sets has,
4524: hr_assignment_set_amendments hasa,
4525: per_assignment_status_types past
4526: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
4527: FROM psp_report_template_details_h prtd
5132: DELETE FROM psp_selected_persons_t
5133: WHERE request_id = p_request_id
5134: AND assignment_id NOT IN (SELECT NVL(paf.assignment_id,0)
5135: FROM per_all_assignments_f paf,
5136: hr_assignment_sets has,
5137: hr_assignment_set_amendments hasa
5138: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
5139: FROM psp_report_template_details_h prtd
5140: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
5652: ELSIF template_sel_criteria.array_sel_criteria(i) = 'AST' THEN
5653: DELETE FROM psp_selected_persons_t
5654: WHERE request_id = p_request_id
5655: AND assignment_id IN (SELECT NVL(paf.assignment_id,0)
5656: FROM per_all_assignments_f paf, hr_assignment_sets has,
5657: hr_assignment_set_amendments hasa
5658: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
5659: FROM psp_report_template_details_h prtd
5660: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'