DBA Data[Home] [Help]

APPS.IGI_CIS2007_TAX_EFF_DATE dependencies on DUAL

Line 275: FROM dual;

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
278: --set the l_tax_name_exists_flag flag to true
279: IF l_old_tax_name = lcr_tax_names.tax_name THEN

Line 368: FROM dual;

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
371: --Records of priority 1 will have end date as NULL
372: INSERT