APPS.HR_LEGISLATION dependencies on PER_ASSIGNMENT_STATUS_TYPES_S

Line 937: select per_assignment_status_types_s.nextval

933: select max(assignment_status_type_id)
934: into v_max_live
935: from per_assignment_status_types;
936:
937: select per_assignment_status_types_s.nextval
938: into v_sequence_number
939: from dual;
940:
941: -- bug 603778

Line 959: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',

955: OR (v_sequence_number < v_max_live) THEN
956:
957: IF v_max_live > v_max_delivered THEN
958:
959: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',
960: v_sequence_number,
961: v_max_live);
962: ELSE
963:

Line 964: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',

960: v_sequence_number,
961: v_max_live);
962: ELSE
963:
964: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',
965: v_sequence_number,
966: v_max_delivered);
967: END IF;
968: END IF;

Line 993: select per_assignment_status_types_s.nextval

989: or (legislation_code = stu_rec.c_leg_code) );
990:
991: EXCEPTION WHEN NO_DATA_FOUND THEN
992:
993: select per_assignment_status_types_s.nextval
994: into l_new_surrogate_key
995: from dual;
996: WHEN TOO_MANY_ROWS THEN
997: hrrunprc_trace_on;