APPS.PAY_TXR_INS dependencies on PAY_TAXABILITY_RULES_DATES

Line 207: from pay_taxability_rules_dates

203: ) is
204: --
205: Cursor C_Sel1 is
206: select taxability_rules_date_id
207: from pay_taxability_rules_dates
208: where legislation_code = p_rec.legislation_code
209: and sysdate between valid_date_from and
210: valid_date_to;
211:

Line 243: ln_rules_nextval pay_taxability_rules_dates.taxability_rules_date_id%TYPE;

239: l_proc varchar2(72) := g_package||'pre_insert';
240: l_exists varchar2(1);
241: l_ele_class_exists varchar2(1);
242: l_sec_ele_class_exists varchar2(1);
243: ln_rules_nextval pay_taxability_rules_dates.taxability_rules_date_id%TYPE;
244: --
245: Begin
246: hr_utility.set_location('Entering:'||l_proc, 5);
247: --

Line 353: --There is no record available for this legislation code in the PAY_TAXABILITY_RULES_DATES.

349: Fetch C_Sel1 Into p_rec.taxability_rules_date_id;
350:
351: IF C_Sel1%NOTFOUND THEN
352:
353: --There is no record available for this legislation code in the PAY_TAXABILITY_RULES_DATES.
354: --So create a record there.
355:
356: select PAY_TAXABILITY_RULES_DATES_S.nextval
357: into ln_rules_nextval

Line 356: select PAY_TAXABILITY_RULES_DATES_S.nextval

352:
353: --There is no record available for this legislation code in the PAY_TAXABILITY_RULES_DATES.
354: --So create a record there.
355:
356: select PAY_TAXABILITY_RULES_DATES_S.nextval
357: into ln_rules_nextval
358: from sys.dual;
359:
360: insert into pay_taxability_rules_dates

Line 360: insert into pay_taxability_rules_dates

356: select PAY_TAXABILITY_RULES_DATES_S.nextval
357: into ln_rules_nextval
358: from sys.dual;
359:
360: insert into pay_taxability_rules_dates
361: (taxability_rules_date_id, valid_date_from, valid_date_to,
362: legislation_code
363: --last_update_date, last_updated_by, last_update_login, created_by, creation_date, object_version_number
364: ) values