APPS.HR_LEGISLATION_LOCAL dependencies on HR_S_TAXABILITY_RULES

Line 331: from hr_s_taxability_rules;

327: , creation_date
328: , rowid
329: , legislation_code
330: , taxability_rules_date_id
331: from hr_s_taxability_rules;
332:
333: stu_rec stu%ROWTYPE;
334:
335: CURSOR c_legs is

Line 348: delete from hr_s_taxability_rules

344:
345: BEGIN
346:
347:
348: delete from hr_s_taxability_rules
349: where rowid = stu_rec.rowid;
350:
351: END remove;
352:

Line 460: -- from hr_s_taxability_rules

456: BEGIN
457:
458: --
459: -- If any rows in pay_taxability_rules do not deliver any rows
460: -- from hr_s_taxability_rules
461: --
462: -- Bug fix for bug no: 1618263
463: -- Added this code because it was not populating the records into pay_
464: -- taxability_rules table for legislation_code 'CA',

Line 468: -- hr_s_taxability_rules data and the 'stu' cursor will not

464: -- taxability_rules table for legislation_code 'CA',
465: -- if there is another legislation_code data already
466: -- installed . Earlier the count(*) from pay_taxability_rules
467: -- will show the count irrespecitve of legislation_code and deletes the
468: -- hr_s_taxability_rules data and the 'stu' cursor will not
469: -- get executed.
470: /* Started code here for bug fix: 1618263 */
471:
472: for legs in c_legs loop

Line 485: delete from hr_s_taxability_rules

481: /* End code here for bug fix: 1618263 */
482:
483: if (l_num_rules <> 0) then
484:
485: delete from hr_s_taxability_rules
486: where legislation_code = l_leg_code;
487:
488: end if;
489: