DBA Data[Home] [Help]

APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_ELEMENT_SETS_S

Line 2814: select pay_element_sets_s.nextval

2810: into v_min_delivered
2811: , v_max_delivered
2812: from hr_s_element_sets;
2813:
2814: select pay_element_sets_s.nextval
2815: into v_sequence_number
2816: from dual;
2817:
2818: IF v_sequence_number

Line 2822: hr_legislation.munge_sequence('PAY_ELEMENT_SETS_S',

2818: IF v_sequence_number
2819: BETWEEN v_min_delivered AND v_max_delivered
2820: THEN
2821:
2822: hr_legislation.munge_sequence('PAY_ELEMENT_SETS_S',
2823: v_sequence_number,
2824: v_max_delivered);
2825:
2826: END IF;

Line 2876: select pay_element_sets_s.nextval

2872:
2873: EXCEPTION WHEN NO_DATA_FOUND THEN
2874:
2875:
2876: select pay_element_sets_s.nextval
2877: into l_new_surrogate_key
2878: from dual;
2879:
2880: WHEN TOO_MANY_ROWS THEN