APPS.HR_LEGISLATION dependencies on PER_ASSIGNMENT_STATUS_TYPES_S

Line 732: select per_assignment_status_types_s.nextval

728: select max(assignment_status_type_id)
729: into v_max_live
730: from per_assignment_status_types;
731:
732: select per_assignment_status_types_s.nextval
733: into v_sequence_number
734: from dual;
735:
736: -- bug 603778

Line 754: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',

750: OR (v_sequence_number < v_max_live) THEN
751:
752: IF v_max_live > v_max_delivered THEN
753:
754: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',
755: v_sequence_number,
756: v_max_live);
757: ELSE
758:

Line 759: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',

755: v_sequence_number,
756: v_max_live);
757: ELSE
758:
759: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',
760: v_sequence_number,
761: v_max_delivered);
762: END IF;
763: END IF;

Line 788: select per_assignment_status_types_s.nextval

784: or (legislation_code = stu_rec.c_leg_code) );
785:
786: EXCEPTION WHEN NO_DATA_FOUND THEN
787:
788: select per_assignment_status_types_s.nextval
789: into l_new_surrogate_key
790: from dual;
791: WHEN TOO_MANY_ROWS THEN
792: hrrunprc_trace_on;