APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_ELEMENT_SETS

Line 2723: from hr_s_element_sets;

2719: , last_update_login
2720: , created_by
2721: , creation_date
2722: , rowid
2723: from hr_s_element_sets;
2724:
2725: CURSOR child_type(ele_set_id number)
2726: IS
2727: -- Cursor to install child element type rules

Line 2782: from hr_s_element_sets b

2778: into l_null_return
2779: from pay_element_sets a
2780: where exists
2781: (select null
2782: from hr_s_element_sets b
2783: where a.element_set_id = b.element_set_id
2784: );
2785:
2786: --conflict may exist

Line 2789: update /*+NO_INDEX*/ hr_s_element_sets

2785:
2786: --conflict may exist
2787: --update all element_set_id's to remove conflict
2788:
2789: update /*+NO_INDEX*/ hr_s_element_sets
2790: set element_set_id = element_set_id - 50000000;
2791:
2792: update /*+NO_INDEX*/ hr_s_element_type_rules
2793: set element_set_id = element_set_id - 50000000;

Line 2812: from hr_s_element_sets;

2808: select min(element_set_id) - (count(*) *3)
2809: , max(element_set_id) + (count(*) *3)
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;

Line 2893: update hr_s_element_sets

2889: raise;
2890: END;
2891:
2892: --update all child entities
2893: update hr_s_element_sets
2894: set element_set_id = l_new_surrogate_key
2895: where element_set_id = stu_rec.c_surrogate_key;
2896:
2897: update hr_s_application_ownerships

Line 2927: delete from hr_s_element_sets

2923:
2924: delete from hr_s_ele_classn_rules
2925: where element_set_id = l_new_surrogate_key;
2926:
2927: delete from hr_s_element_sets
2928: where rowid = stu_rec.rowid;
2929:
2930: END remove;
2931: