APPS.ZX_MIGRATE_TAX_DEF dependencies on DUAL

Line 575: SELECT 1 FROM DUAL;

571: SYSDATE ,
572: fnd_global.user_id ,
573: fnd_global.conc_login_id
574: )
575: SELECT 1 FROM DUAL;
576:
577: INSERT INTO FND_LOOKUP_TYPES_TL
578: (
579: LOOKUP_TYPE,

Line 8799: FROM DUAL

8795: fnd_global.prog_appl_id ,--Program Application ID
8796: fnd_global.conc_program_id ,--Program Id
8797: fnd_global.conc_login_id , --Program Login ID
8798: 1
8799: FROM DUAL
8800: WHERE not exists (select 1
8801: from ZX_DET_FACTOR_TEMPL_B
8802: where DET_FACTOR_TEMPL_CODE =
8803: 'EX Acct String Range-Party FC'

Line 10306: FROM DUAL WHERE NOT EXISTS

10302: pg_max_ledger_id_tab(j),
10303: pg_max_org_id_tab(j),
10304: 1
10305:
10306: FROM DUAL WHERE NOT EXISTS
10307: ( SELECT NULL FROM ZX_ACCOUNTS accounts
10308: WHERE accounts.TAX_ACCOUNT_ENTITY_CODE = 'TAXES' and
10309: accounts.TAX_ACCOUNT_ENTITY_ID = pg_max_tax_id_tab(j)
10310: )

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

10410: arp_util_tax.debug('Migrate_Disabled_Tax_Codes');
10411: END IF;
10412:
10413: BEGIN
10414: SELECT sysdate-999999 into l_min_start_date from dual;
10415: SELECT sysdate+999999 into l_max_end_date from dual;
10416: EXCEPTION WHEN OTHERS THEN
10417: NULL;
10418: END;

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

10411: END IF;
10412:
10413: BEGIN
10414: SELECT sysdate-999999 into l_min_start_date from dual;
10415: SELECT sysdate+999999 into l_max_end_date from dual;
10416: EXCEPTION WHEN OTHERS THEN
10417: NULL;
10418: END;
10419:

Line 14043: SELECT 'Y' INTO ID_CLASH FROM DUAL

14039: /* Constructor */
14040: BEGIN
14041: BEGIN
14042:
14043: SELECT 'Y' INTO ID_CLASH FROM DUAL
14044: WHERE EXISTS (select 1
14045: from ap_tax_codes_all,
14046: ar_vat_tax_all_b
14047: where tax_id = vat_tax_id);