APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on DUAL

Line 1375: SELECT 1 FROM DUAL;

1371: fnd_global.user_id ,
1372: fnd_global.conc_login_id ,
1373: ZX_REGIMES_B_S.NEXTVAL
1374: )
1375: SELECT 1 FROM DUAL;
1376:
1377: *
1378: * End of commenting out zx_regimes_b/_tl population logic
1379: */

Line 6556: SELECT 1 FROM DUAL;

6552: fnd_global.user_id,
6553: fnd_global.conc_login_id,
6554: ZX_TAXES_B_S.NEXTVAL
6555: )*/
6556: SELECT 1 FROM DUAL;
6557:
6558: EXCEPTION
6559: WHEN OTHERS THEN
6560: NULL;

Line 10208: SELECT 1 FROM DUAL;

10204: NULL ,--ATTRIBUTE15
10205: NULL ,--ATTRIBUTE_CATEGORY
10206: 1
10207: )
10208: SELECT 1 FROM DUAL;
10209:
10210: EXCEPTION
10211: WHEN OTHERS THEN
10212: NULL;

Line 10367: SELECT 'Y' INTO L_LTE_USED FROM DUAL

10363: BEGIN
10364: -- Check if LTE is used
10365: /* Bug 5248597*/
10366: /*BEGIN
10367: SELECT 'Y' INTO L_LTE_USED FROM DUAL
10368: WHERE EXISTS (select 1
10369: from ar_vat_tax_all_b
10370: where global_attribute_category in ('JL.AR.ARXSUVAT.AR_VAT_TAX',
10371: 'JL.BR.ARXSUVAT.AR_VAT_TAX',

Line 10383: SELECT 'Y' INTO L_JATW_USED FROM DUAL

10379: END;*/
10380:
10381: -- Check if JATW is used
10382: BEGIN
10383: SELECT 'Y' INTO L_JATW_USED FROM DUAL
10384: WHERE EXISTS (select 1
10385: from ar_vat_tax_all_b
10386: where global_attribute_category = 'JA.TW.ARXSUVAT.VAT_TAX'); --YK:B:10/08/2004: Modified.
10387: EXCEPTION