APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on HR_ASSIGNMENT_SETS

Line 518: SELECT hr_assignment_sets_s.nextval

514: FROM per_all_people_f
515: WHERE person_id = c_person_id;
516:
517: CURSOR c_assignment_set_id IS
518: SELECT hr_assignment_sets_s.nextval
519: FROM dual;
520:
521: CURSOR c_assignment_set_exists(assign_set_name VARCHAR2) IS
522: SELECT assignment_set_id

Line 523: FROM hr_assignment_sets

519: FROM dual;
520:
521: CURSOR c_assignment_set_exists(assign_set_name VARCHAR2) IS
522: SELECT assignment_set_id
523: FROM hr_assignment_sets
524: WHERE assignment_set_name=assign_set_name;
525:
526: CURSOR c_assignment_amd_exists(c_assignment_id number,
527: c_assignment_set_id number) IS

Line 714: /* Inserting the New Assignment set into hr_assignment_sets table */

710: OPEN c_assignment_set_id;
711: FETCH c_assignment_set_id into lv_assignment_set_id;
712: CLOSE c_assignment_set_id;
713:
714: /* Inserting the New Assignment set into hr_assignment_sets table */
715: hr_assignment_sets_pkg.insert_row(row_id,
716: lv_assignment_set_id,
717: p_bus_grp,
718: lv_payroll_id,

Line 715: hr_assignment_sets_pkg.insert_row(row_id,

711: FETCH c_assignment_set_id into lv_assignment_set_id;
712: CLOSE c_assignment_set_id;
713:
714: /* Inserting the New Assignment set into hr_assignment_sets table */
715: hr_assignment_sets_pkg.insert_row(row_id,
716: lv_assignment_set_id,
717: p_bus_grp,
718: lv_payroll_id,
719: p_assign_set,