APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_ELEMENT_SETS

Line 2691: from hr_s_element_sets;

2687: , last_update_login
2688: , created_by
2689: , creation_date
2690: , rowid
2691: from hr_s_element_sets;
2692:
2693: CURSOR child_type(ele_set_id number)
2694: IS
2695: -- Cursor to install child element type rules

Line 2750: from hr_s_element_sets b

2746: into l_null_return
2747: from pay_element_sets a
2748: where exists
2749: (select null
2750: from hr_s_element_sets b
2751: where a.element_set_id = b.element_set_id
2752: );
2753:
2754: --conflict may exist

Line 2757: update /*+NO_INDEX*/ hr_s_element_sets

2753:
2754: --conflict may exist
2755: --update all element_set_id's to remove conflict
2756:
2757: update /*+NO_INDEX*/ hr_s_element_sets
2758: set element_set_id = element_set_id - 50000000;
2759:
2760: update /*+NO_INDEX*/ hr_s_element_type_rules
2761: set element_set_id = element_set_id - 50000000;

Line 2780: from hr_s_element_sets;

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

Line 2861: update hr_s_element_sets

2857: raise;
2858: END;
2859:
2860: --update all child entities
2861: update hr_s_element_sets
2862: set element_set_id = l_new_surrogate_key
2863: where element_set_id = stu_rec.c_surrogate_key;
2864:
2865: update hr_s_application_ownerships

Line 2895: delete from hr_s_element_sets

2891:
2892: delete from hr_s_ele_classn_rules
2893: where element_set_id = l_new_surrogate_key;
2894:
2895: delete from hr_s_element_sets
2896: where rowid = stu_rec.rowid;
2897:
2898: END remove;
2899: