DBA Data[Home] [Help]

APPS.IGI_CIS2007_TAX_EFF_DATE dependencies on AP_AWT_TAX_RATES_S

Line 273: SELECT ap_awt_tax_rates_s.nextval

269: AND tax_name = lcr_tax_names.tax_name
270: AND priority = 2;
271:
272: --Fetch a new tax rate id from the sequence
273: SELECT ap_awt_tax_rates_s.nextval
274: INTO l_new_tax_rate_id
275: FROM dual;
276:
277: --If a record corrosponding to the old tax name already exists then

Line 366: SELECT ap_awt_tax_rates_s.nextval

362:
363: --A record for l_old_tax_name does not exists. Insert this record
364: IF l_tax_name_exists_flag = FALSE THEN --Start of l_tax_name_exists_flag IF
365:
366: SELECT ap_awt_tax_rates_s.nextval
367: INTO l_new_tax_rate_id
368: FROM dual;
369:
370: --Insert a new record for the l_old_tax_name with priority 1