APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_ELEMENT_CLASSIFICATIONS

Line 41: from hr_s_element_classifications

37: , created_by
38: , creation_date
39: , balance_initialization_flag
40: , FREQ_RULE_ENABLED
41: from hr_s_element_classifications
42: order by parent_classification_id desc;
43:
44: stu_rec stu%ROWTYPE;
45:

Line 107: from hr_s_element_classifications b

103: into l_null_return
104: from pay_element_classifications a
105: where exists
106: (select null
107: from hr_s_element_classifications b
108: where a.classification_id = b.classification_id
109: );
110:
111: --conflict may exist

Line 114: update /*+NO_INDEX*/ hr_s_element_classifications

110:
111: --conflict may exist
112: --update all classification_id's to remove conflict
113:
114: update /*+NO_INDEX*/ hr_s_element_classifications
115: set classification_id = classification_id - 50000000
116: ,parent_classification_id = parent_classification_id - 50000000;
117:
118: update /*+NO_INDEX*/ hr_s_BALANCE_CLASSIFICATIONS

Line 151: from hr_s_element_classifications;

147: select min(classification_id) - (count(*) *3)
148: , max(classification_id) + (count(*) *3)
149: into v_min_delivered
150: , v_max_delivered
151: from hr_s_element_classifications;
152:
153: select pay_element_classifications_s.nextval
154: into v_sequence_number
155: from dual;

Line 201: from hr_s_element_classifications

197: -- Start the checking against the first parent table
198:
199: select distinct null
200: into l_null_return
201: from hr_s_element_classifications
202: where classification_id = stu_rec.parent_classification_id;
203:
204: crt_exc('Parent classification remains in delivery tables');
205:

Line 280: update hr_s_element_classifications

276: END;
277:
278: -- Update all child entities
279:
280: update hr_s_element_classifications
281: set classification_id = l_new_surrogate_key
282: where classification_id = stu_rec.c_surrogate_key;
283:
284: update hr_s_element_classifications

Line 284: update hr_s_element_classifications

280: update hr_s_element_classifications
281: set classification_id = l_new_surrogate_key
282: where classification_id = stu_rec.c_surrogate_key;
283:
284: update hr_s_element_classifications
285: set parent_classification_id = l_new_surrogate_key
286: where parent_classification_id = stu_rec.c_surrogate_key;
287:
288: update hr_s_application_ownerships

Line 323: delete from hr_s_element_classifications

319:
320: BEGIN
321:
322:
323: delete from hr_s_element_classifications
324: where rowid = stu_rec.rowid;
325:
326: -- #334582 If the row is being removed 'undelivered' i.e. it's not
327: -- required in this installation, remove its child

Line 1642: from hr_s_element_classifications

1638: -- Check first parent does not exist in the delivery tables
1639:
1640: select null
1641: into l_null_return
1642: from hr_s_element_classifications
1643: where classification_id = r_each_row.classification_id;
1644:
1645:
1646: crt_exc('Parent classification still exists in delivery tables','I');