APPS.ZX_MIGRATE_TAX_DEF dependencies on DUAL

Line 600: SELECT 1 FROM DUAL;

596: fnd_global.user_id ,
597: fnd_global.conc_login_id
598: )
599:
600: SELECT 1 FROM DUAL;
601:
602: INSERT INTO FND_LOOKUP_TYPES_TL
603: (
604: LOOKUP_TYPE,

Line 8821: FROM DUAL

8817: fnd_global.prog_appl_id ,--Program Application ID
8818: fnd_global.conc_program_id ,--Program Id
8819: fnd_global.conc_login_id , --Program Login ID
8820: 1
8821: FROM DUAL
8822: WHERE not exists (select 1
8823: from ZX_DET_FACTOR_TEMPL_B
8824: where DET_FACTOR_TEMPL_CODE =
8825: 'EX Acct String Range-Party FC'

Line 10639: FROM DUAL WHERE NOT EXISTS

10635: pg_max_ledger_id_tab(j),
10636: pg_max_org_id_tab(j),
10637: 1
10638:
10639: FROM DUAL WHERE NOT EXISTS
10640: ( SELECT NULL FROM ZX_ACCOUNTS accounts
10641: WHERE accounts.TAX_ACCOUNT_ENTITY_CODE = 'TAXES' and
10642: accounts.TAX_ACCOUNT_ENTITY_ID = pg_max_tax_id_tab(j)
10643: )

Line 10747: SELECT sysdate-999999 into l_min_start_date from dual;

10743: arp_util_tax.debug('Migrate_Disabled_Tax_Codes');
10744: END IF;
10745:
10746: BEGIN
10747: SELECT sysdate-999999 into l_min_start_date from dual;
10748: SELECT sysdate+999999 into l_max_end_date from dual;
10749: EXCEPTION WHEN OTHERS THEN
10750: NULL;
10751: END;

Line 10748: SELECT sysdate+999999 into l_max_end_date from dual;

10744: END IF;
10745:
10746: BEGIN
10747: SELECT sysdate-999999 into l_min_start_date from dual;
10748: SELECT sysdate+999999 into l_max_end_date from dual;
10749: EXCEPTION WHEN OTHERS THEN
10750: NULL;
10751: END;
10752:

Line 14368: SELECT 'Y' INTO ID_CLASH FROM DUAL

14364: /* Constructor */
14365: BEGIN
14366: BEGIN
14367:
14368: SELECT 'Y' INTO ID_CLASH FROM DUAL
14369: WHERE EXISTS (select 1
14370: from ap_tax_codes_all,
14371: ar_vat_tax_all_b
14372: where tax_id = vat_tax_id);