DBA Data[Home] [Help]

APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_ELEMENT_SETS_S

Line 2782: select pay_element_sets_s.nextval

2778: into v_min_delivered
2779: , v_max_delivered
2780: from hr_s_element_sets;
2781:
2782: select pay_element_sets_s.nextval
2783: into v_sequence_number
2784: from dual;
2785:
2786: IF v_sequence_number

Line 2790: hr_legislation.munge_sequence('PAY_ELEMENT_SETS_S',

2786: IF v_sequence_number
2787: BETWEEN v_min_delivered AND v_max_delivered
2788: THEN
2789:
2790: hr_legislation.munge_sequence('PAY_ELEMENT_SETS_S',
2791: v_sequence_number,
2792: v_max_delivered);
2793:
2794: END IF;

Line 2844: select pay_element_sets_s.nextval

2840:
2841: EXCEPTION WHEN NO_DATA_FOUND THEN
2842:
2843:
2844: select pay_element_sets_s.nextval
2845: into l_new_surrogate_key
2846: from dual;
2847:
2848: WHEN TOO_MANY_ROWS THEN