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 231: ln_rules_nextval pay_taxability_rules_dates.taxability_rules_date_id%TYPE;

227: pay_txr_ins.g_taxability_rules_date_id_i;
228: --
229: l_proc varchar2(72) := g_package||'pre_insert';
230: l_exists varchar2(1);
231: ln_rules_nextval pay_taxability_rules_dates.taxability_rules_date_id%TYPE;
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --

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

292: Fetch C_Sel1 Into p_rec.taxability_rules_date_id;
293:
294: IF C_Sel1%NOTFOUND THEN
295:
296: --There is no record available for this legislation code in the PAY_TAXABILITY_RULES_DATES.
297: --So create a record there.
298:
299: select PAY_TAXABILITY_RULES_DATES_S.nextval
300: into ln_rules_nextval

Line 299: select PAY_TAXABILITY_RULES_DATES_S.nextval

295:
296: --There is no record available for this legislation code in the PAY_TAXABILITY_RULES_DATES.
297: --So create a record there.
298:
299: select PAY_TAXABILITY_RULES_DATES_S.nextval
300: into ln_rules_nextval
301: from sys.dual;
302:
303: insert into pay_taxability_rules_dates

Line 303: insert into pay_taxability_rules_dates

299: select PAY_TAXABILITY_RULES_DATES_S.nextval
300: into ln_rules_nextval
301: from sys.dual;
302:
303: insert into pay_taxability_rules_dates
304: (taxability_rules_date_id, valid_date_from, valid_date_to,
305: legislation_code
306: --last_update_date, last_updated_by, last_update_login, created_by, creation_date, object_version_number
307: ) values