APPS.ZX_AR_FORMULA_MIG_PKG dependencies on DUAL

Line 823: FROM DUAL

819: fnd_global.prog_appl_id, --Program Application ID
820: fnd_global.conc_program_id, --Program Id
821: fnd_global.conc_login_id, --Program Login ID
822: 1
823: FROM DUAL
824: WHERE
825: --Re-runnability
826: NOT EXISTS ( SELECT 1
827: FROM zx_formula_b

Line 1070: FROM DUAL;

1066: 1,
1067: SUBSTRB('O_TB_' || p_tax,1,24)||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_RULES_B_S'),
1068: 'O_TB_' || p_tax)
1069: INTO l_tax_rule_code
1070: FROM DUAL;
1071:
1072: arp_util_tax.debug('l_tax_rule_code'||l_tax_rule_code);
1073:
1074: -- Inserting values in table zx_rules_b

Line 1131: FROM DUAL

1127: fnd_global.prog_appl_id, --Program Application ID
1128: fnd_global.conc_program_id, --Program Id
1129: fnd_global.conc_login_id, --Program Login ID
1130: 1
1131: FROM DUAL
1132: WHERE
1133: --Re-runnability
1134:
1135: NOT EXISTS (SELECT 1

Line 1141: FROM DUAL)

1137: WHERE substrb(tax_rule_code,1,24) = (SELECT DECODE(SIGN(LENGTHB('O_TB_' || p_tax) - 30),
1138: 1,
1139: SUBSTRB('O_TB_' || p_tax,1,24),
1140: SUBSTRB('O_TB_' || p_tax,1,24))
1141: FROM DUAL)
1142: AND content_owner_id = p_content_owner_id
1143: AND tax_regime_code = p_tax_regime_code
1144: AND tax = p_tax
1145: AND (effective_from BETWEEN p_effective_from AND NVL(p_effective_to,SYSDATE)

Line 1299: FROM dual

1295: fnd_global.prog_appl_id, --Program Application ID
1296: fnd_global.conc_program_id, --Program Id
1297: fnd_global.conc_login_id, --Program Login ID
1298: 1
1299: FROM dual
1300: WHERE
1301: --Re-runnability
1302: NOT EXISTS (SELECT 1
1303: FROM zx_process_results