[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)
2340: DELETE FROM psp_selected_persons_t
2341: WHERE request_id = p_request_id
2342: AND person_id NOT IN (SELECT NVL(paf.person_id,0)
2343: FROM per_all_assignments_f paf,
2344: hr_assignment_sets has,
2345: hr_assignment_set_amendments hasa,
2346: per_assignment_status_types past
2347: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
2348: FROM psp_report_template_details_h prtd
3222: DELETE FROM psp_selected_persons_t
3223: WHERE request_id = p_request_id
3224: AND person_id IN (SELECT NVL(paf.person_id,0)
3225: FROM per_all_assignments_f paf,
3226: hr_assignment_sets has,
3227: hr_assignment_set_amendments hasa,
3228: per_assignment_status_types past
3229: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
3230: FROM psp_report_template_details_h prtd
3959: INSERT INTO psp_selection_cardinality_gt
3960: (lookup_code, total_count)
3961: SELECT 'AST', COUNT(DISTINCT paf.assignment_id)
3962: FROM per_all_assignments_f paf,
3963: hr_assignment_sets has ,
3964: hr_assignment_set_amendments hasa
3965: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
3966: FROM psp_report_template_details_h prtd
3967: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
4552:
4553: INSERT INTO psp_selected_persons_t (request_id, person_id, assignment_id)
4554: SELECT DISTINCT p_request_id, person_id, paf.assignment_id
4555: FROM per_all_assignments_f paf,
4556: hr_assignment_sets has,
4557: hr_assignment_set_amendments hasa,
4558: per_assignment_status_types past
4559: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
4560: FROM psp_report_template_details_h prtd
5165: DELETE FROM psp_selected_persons_t
5166: WHERE request_id = p_request_id
5167: AND assignment_id NOT IN (SELECT NVL(paf.assignment_id,0)
5168: FROM per_all_assignments_f paf,
5169: hr_assignment_sets has,
5170: hr_assignment_set_amendments hasa
5171: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
5172: FROM psp_report_template_details_h prtd
5173: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'
5685: ELSIF template_sel_criteria.array_sel_criteria(i) = 'AST' THEN
5686: DELETE FROM psp_selected_persons_t
5687: WHERE request_id = p_request_id
5688: AND assignment_id IN (SELECT NVL(paf.assignment_id,0)
5689: FROM per_all_assignments_f paf, hr_assignment_sets has,
5690: hr_assignment_set_amendments hasa
5691: WHERE has.assignment_set_id IN (SELECT TO_NUMBER(criteria_value1)
5692: FROM psp_report_template_details_h prtd
5693: WHERE criteria_lookup_type='PSP_SELECTION_CRITERIA'