APPS.HR_LEGISLATION_BENEFITS dependencies on BEN_BENEFIT_CLASSIFICATIONS_S

Line 670: select ben_benefit_classifications_s.nextval

666: into v_min_delivered
667: , v_max_delivered
668: from hr_s_benefit_classifications;
669:
670: select ben_benefit_classifications_s.nextval
671: into v_sequence_number
672: from dual;
673:
674: WHILE

Line 679: select ben_benefit_classifications_s.nextval

675: v_sequence_number BETWEEN v_min_delivered AND v_max_delivered
676: LOOP
677:
678:
679: select ben_benefit_classifications_s.nextval
680: into v_sequence_number
681: from dual;
682:
683: END LOOP;

Line 732: select ben_benefit_classifications_s.nextval

728:
729: EXCEPTION WHEN NO_DATA_FOUND THEN
730:
731:
732: select ben_benefit_classifications_s.nextval
733: into l_new_surrogate_key
734: from dual;
735:
736: END;