APPS.HR_LEGISLATION_LOCAL dependencies on PAY_TAXABILITY_RULES_DATES

Line 370: from pay_taxability_rules_dates

366:
367: BEGIN
368: select taxability_rules_date_id
369: into l_trd_id
370: from pay_taxability_rules_dates
371: where legislation_code = stu_rec.legislation_code
372: and trunc(valid_date_from) = trunc(to_date('0001/01/01', 'YYYY/MM/DD'))
373: and trunc(valid_date_to) = trunc(to_date('4712/12/31', 'YYYY/MM/DD'));
374:

Line 378: select pay_taxability_rules_dates_s.nextval

374:
375: EXCEPTION
376: when NO_DATA_FOUND then
377:
378: select pay_taxability_rules_dates_s.nextval
379: into l_trd_id
380: from dual;
381:
382: insert into pay_taxability_rules_dates

Line 382: insert into pay_taxability_rules_dates

378: select pay_taxability_rules_dates_s.nextval
379: into l_trd_id
380: from dual;
381:
382: insert into pay_taxability_rules_dates
383: ( taxability_rules_date_id,
384: valid_date_from,
385: valid_date_to,
386: legislation_code)