APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on DUAL

Line 1289: SELECT 1 FROM DUAL;

1285: fnd_global.user_id ,
1286: fnd_global.conc_login_id ,
1287: ZX_REGIMES_B_S.NEXTVAL
1288: )
1289: SELECT 1 FROM DUAL;
1290:
1291: *
1292: * End of commenting out zx_regimes_b/_tl population logic
1293: */

Line 6544: SELECT 1 FROM DUAL;

6540: fnd_global.user_id,
6541: fnd_global.conc_login_id,
6542: ZX_TAXES_B_S.NEXTVAL
6543: )*/
6544: SELECT 1 FROM DUAL;
6545:
6546: EXCEPTION
6547: WHEN OTHERS THEN
6548: NULL;

Line 10155: SELECT 1 FROM DUAL;

10151: NULL ,--ATTRIBUTE15
10152: NULL ,--ATTRIBUTE_CATEGORY
10153: 1
10154: )
10155: SELECT 1 FROM DUAL;
10156:
10157: -- *** Note *** Need to insert into _tl as we're creating new records
10158: INSERT INTO ZX_RATES_TL
10159: (

Line 10358: SELECT 'Y' INTO L_LTE_USED FROM DUAL

10354: BEGIN
10355: -- Check if LTE is used
10356: /* Bug 5248597*/
10357: /*BEGIN
10358: SELECT 'Y' INTO L_LTE_USED FROM DUAL
10359: WHERE EXISTS (select 1
10360: from ar_vat_tax_all_b
10361: where global_attribute_category in ('JL.AR.ARXSUVAT.AR_VAT_TAX',
10362: 'JL.BR.ARXSUVAT.AR_VAT_TAX',

Line 10374: SELECT 'Y' INTO L_JATW_USED FROM DUAL

10370: END;*/
10371:
10372: -- Check if JATW is used
10373: BEGIN
10374: SELECT 'Y' INTO L_JATW_USED FROM DUAL
10375: WHERE EXISTS (select 1
10376: from ar_vat_tax_all_b
10377: where global_attribute_category = 'JA.TW.ARXSUVAT.VAT_TAX'); --YK:B:10/08/2004: Modified.
10378: EXCEPTION