47: c_missing_assignments to select
48: only primary assignments.
49: 29-AUG-2003 rsethupa 115.3 2527077 Added Comments.
50: 10-SEP-2003 rsethupa 115.4 3135440 Modified call to procedure
51: hr_assignment_sets_pkg.insert_row
52: to create assignment set, by
53: passing the business_group_id
54: of the assignment instead of
55: tax unit ID/GRE ID
370: WHERE person_id = c_person_id;
371:
372: CURSOR c_assignment_set_id
373: IS
374: SELECT hr_assignment_sets_s.nextval
375: FROM dual;
376:
377: CURSOR c_assignment_set_exists(assign_set_name VARCHAR2)
378: IS
376:
377: CURSOR c_assignment_set_exists(assign_set_name VARCHAR2)
378: IS
379: SELECT assignment_set_id
380: FROM hr_assignment_sets
381: WHERE assignment_set_name=assign_set_name;
382:
383: CURSOR c_assignment_amd_exists(c_assignment_id number,c_assignment_set_id number)
384: IS
577: IF lv_assignment_set_id=0 THEN
578: OPEN c_assignment_set_id;
579: FETCH c_assignment_set_id into lv_assignment_set_id;
580: CLOSE c_assignment_set_id;
581: hr_assignment_sets_pkg.insert_row(row_id,
582: lv_assignment_set_id,
583: lv_business_group_id,
584: lv_payroll_id,
585: lv_assignment_set,