APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_TAXABILITY_RULES

Line 134: update /*+NO_INDEX*/ hr_s_TAXABILITY_RULES

130: --
131: -- #346359 ensure STU_TAXABILITY_RULES classification_id is kept
132: -- in step along with the rest of the children.
133: --
134: update /*+NO_INDEX*/ hr_s_TAXABILITY_RULES
135: set classification_id = classification_id - 50000000;
136:
137: update hr_s_application_ownerships
138: set key_value = key_value - 50000000

Line 309: update hr_s_taxability_rules

305: update hr_s_ele_classn_rules
306: set classification_id = l_new_surrogate_key
307: where classification_id = stu_rec.c_surrogate_key;
308:
309: update hr_s_taxability_rules
310: set classification_id = l_new_surrogate_key
311: where classification_id = stu_rec.c_surrogate_key;
312:
313: END update_uid;

Line 328: -- hr_s_taxability_rules rows here, so we don't get a later FKEY

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
328: -- hr_s_taxability_rules rows here, so we don't get a later FKEY
329: -- constraint violation.
330: --
331: if (p_delivered = 'N') then
332: delete from hr_s_taxability_rules

Line 332: delete from hr_s_taxability_rules

328: -- hr_s_taxability_rules rows here, so we don't get a later FKEY
329: -- constraint violation.
330: --
331: if (p_delivered = 'N') then
332: delete from hr_s_taxability_rules
333: where classification_id = stu_rec.c_surrogate_key;
334: end if;
335:
336: END remove;