DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_MIGRATE_UTIL

Line 9169: zx_migrate_util.get_country(fsp.org_id) ,--COUNTRY_CODE

9165: OVER (PARTITION BY RATES.rule_id ORDER BY
9166: RATES.rate_id) ,--CONDITION_GROUP_CODE
9167: 'EX Acct String Range-Party FC' ,--DET_FACTOR_TEMPL_CODE
9168: --Review1 changes
9169: zx_migrate_util.get_country(fsp.org_id) ,--COUNTRY_CODE
9170: 'N' ,--MORE_THAN_MAX_COND_FLAG
9171: 'Y' ,--ENABLED_FLAG
9172: 'LINE_ACCOUNT' , --DETERMINING_FACTOR_CODE1 ----Bug 5247466
9173: 'ACCOUNT' ,--TAX_PARAMETER_CODE1 ----Bug 5247466

Line 9301: zx_migrate_util.get_country(fsp.org_id) ,--COUNTRY_CODE

9297: OVER (PARTITION BY RATES.rule_id ORDER BY
9298: RATES.rate_id) ,--CONDITION_GROUP_CODE
9299: 'EX Acct String Range-Party FC' ,--DET_FACTOR_TEMPL_CODE
9300: --Review1 changes
9301: zx_migrate_util.get_country(fsp.org_id) ,--COUNTRY_CODE
9302: 'N' ,--MORE_THAN_MAX_COND_FLAG
9303: 'Y' ,--ENABLED_FLAG
9304: 'LINE_ACCOUNT' , --DETERMINING_FACTOR_CODE1 ----Bug 5247466
9305: 'ACCOUNT' ,--TAX_PARAMETER_CODE1 ----Bug 5247466

Line 9439: zx_migrate_util.get_country(fsp.org_id) ,--COUNTRY_CODE

9435: OVER (PARTITION BY RATES.rule_id ORDER BY
9436: RATES.rate_id) ,--CONDITION_GROUP_CODE
9437: 'EX Acct String Range-Party FC' ,--DET_FACTOR_TEMPL_CODE
9438: --Review1 changes
9439: zx_migrate_util.get_country(fsp.org_id) ,--COUNTRY_CODE
9440: 'N' ,--MORE_THAN_MAX_COND_FLAG
9441: 'Y' ,--ENABLED_FLAG
9442: 'LINE_ACCOUNT' , --DETERMINING_FACTOR_CODE1 ----Bug 5247466
9443: 'ACCOUNT' ,--TAX_PARAMETER_CODE1 ----Bug 5247466

Line 9573: zx_migrate_util.get_country(fsp.org_id) ,--COUNTRY_CODE

9569: OVER (PARTITION BY RATES.rule_id ORDER BY
9570: RATES.rate_id) ,--CONDITION_GROUP_CODE
9571: 'EX Acct String Range-Party FC' ,--DET_FACTOR_TEMPL_CODE
9572: --Review1 changes
9573: zx_migrate_util.get_country(fsp.org_id) ,--COUNTRY_CODE
9574: 'N' ,--MORE_THAN_MAX_COND_FLAG
9575: 'Y' ,--ENABLED_FLAG
9576: 'LINE_ACCOUNT' , --DETERMINING_FACTOR_CODE1 ----Bug 5247466
9577: 'ACCOUNT' ,--TAX_PARAMETER_CODE1 ----Bug 5247466

Line 9818: 1, SUBSTRB(RULES.NAME,1,24)||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_RULES_B_S'),

9814: group by name having count(*)>1)
9815: THEN
9816: --check if ap_tax_recvry_rules_all.NAME || rates.TAX is more than 30 characters in length
9817: DECODE(SIGN(LENGTHB(RULES.NAME||RATES.TAX)-30),
9818: 1, SUBSTRB(RULES.NAME,1,24)||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_RULES_B_S'),
9819: RULES.NAME||RATES.TAX)
9820: ELSE -- else for GROUP BY CHECKING
9821: RULES.NAME
9822: END TAX_RULE_CODE,

Line 9930: 1, SUBSTRB(RULES.NAME,1,24)||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_RULES_B_S'),

9926: )
9927: THEN
9928: --check if ap_tax_recvry_rules_all.NAME || rates.TAX is more than 30 characters in length
9929: DECODE(SIGN(LENGTHB(RULES.NAME||RATES.TAX)-30),
9930: 1, SUBSTRB(RULES.NAME,1,24)||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_RULES_B_S'),
9931: RULES.NAME||RATES.TAX
9932: )
9933: ELSE -- else for GROUP BY CHECKING
9934: RULES.NAME