APPS.ZX_AR_FORMULA_MIG_PKG dependencies on DUAL

Line 336: FROM DUAL;

332: 1,
333: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S'),
334: l_tax_group_code||'_'||l_child_tax_code||'_TB')
335: INTO l_formula_code
336: FROM DUAL;
337:
338: -- For width Issue (formula_code is VARCHAR2(30) only)
339:
340: arp_util_tax.debug('case 3:l_formula_code:'||l_formula_code);

Line 556: FROM DUAL;

552: 1,
553: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S' ),
554: l_tax_group_code||'_'||l_child_tax_code||'_TB')
555: INTO l_formula_code
556: FROM DUAL;
557:
558: arp_util_tax.debug('case 4: l_formula_code1'||l_formula_code);
559:
560:

Line 620: FROM DUAL;

616: 1,
617: SUBSTRB(l_tax_group_code||'_'||l_child_tax_code,1,24) ||'_TB'||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_FORMULA_B_S' ),
618: l_tax_group_code||'_'||l_child_tax_code||'_TB')
619: INTO l_formula_code
620: FROM DUAL;
621:
622: l_discount_flag := 'N';
623: l_charge_flag := 'N';
624:

Line 808: FROM DUAL

804: fnd_global.prog_appl_id ,--Program Application ID
805: fnd_global.conc_program_id ,--Program Id
806: fnd_global.conc_login_id ,--Program Login ID
807: 1
808: FROM DUAL
809: WHERE
810: --Re-runnability
811: NOT EXISTS ( SELECT 1
812: FROM zx_formula_b

Line 916: FROM DUAL

912: fnd_global.conc_program_id ,--Program Id
913: fnd_global.conc_login_id ,--Program Login ID
914: 1
915:
916: FROM DUAL
917: WHERE
918: --Re-runnability
919: NOT EXISTS (SELECT 1
920: FROM zx_formula_details, zx_formula_b

Line 1033: FROM DUAL;

1029: 1,
1030: SUBSTRB('O_TB_' || p_tax,1,24)||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_RULES_B_S'),
1031: 'O_TB_' || p_tax)
1032: INTO l_tax_rule_code
1033: FROM DUAL;
1034:
1035: arp_util_tax.debug('l_tax_rule_code'||l_tax_rule_code);
1036:
1037: -- Inserting values in table zx_rules_b

Line 1094: FROM DUAL

1090: fnd_global.prog_appl_id ,--Program Application ID
1091: fnd_global.conc_program_id ,--Program Id
1092: fnd_global.conc_login_id ,--Program Login ID
1093: 1
1094: FROM DUAL
1095: WHERE
1096: --Re-runnability
1097:
1098: NOT EXISTS (SELECT 1

Line 1104: FROM DUAL)

1100: WHERE substrb(tax_rule_code,1,24) = (SELECT DECODE(SIGN(LENGTHB('O_TB_' || p_tax) - 30),
1101: 1,
1102: SUBSTRB('O_TB_' || p_tax,1,24),
1103: SUBSTRB('O_TB_' || p_tax,1,24))
1104: FROM DUAL)
1105: AND content_owner_id = p_content_owner_id
1106: AND tax_regime_code = p_tax_regime_code
1107: AND (effective_from BETWEEN p_effective_from AND NVL(p_effective_to,SYSDATE)
1108: OR

Line 1242: FROM dual

1238: fnd_global.conc_program_id ,--Program Id
1239: fnd_global.conc_login_id ,--Program Login ID
1240: 1
1241:
1242: FROM dual
1243: WHERE
1244: --Re-runnability
1245: NOT EXISTS (SELECT 1
1246: FROM zx_process_results, zx_rules_b