APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_MIGRATE_UTIL

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

9143: OVER (PARTITION BY RATES.rule_id ORDER BY
9144: RATES.rate_id) ,--CONDITION_GROUP_CODE
9145: 'EX Acct String Range-Party FC' ,--DET_FACTOR_TEMPL_CODE
9146: --Review1 changes
9147: zx_migrate_util.get_country(fsp.org_id) ,--COUNTRY_CODE
9148: 'N' ,--MORE_THAN_MAX_COND_FLAG
9149: 'Y' ,--ENABLED_FLAG
9150: 'LINE_ACCOUNT' , --DETERMINING_FACTOR_CODE1 ----Bug 5247466
9151: 'ACCOUNT' ,--TAX_PARAMETER_CODE1 ----Bug 5247466

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

9274: OVER (PARTITION BY RATES.rule_id ORDER BY
9275: RATES.rate_id) ,--CONDITION_GROUP_CODE
9276: 'EX Acct String Range-Party FC' ,--DET_FACTOR_TEMPL_CODE
9277: --Review1 changes
9278: zx_migrate_util.get_country(fsp.org_id) ,--COUNTRY_CODE
9279: 'N' ,--MORE_THAN_MAX_COND_FLAG
9280: 'Y' ,--ENABLED_FLAG
9281: 'LINE_ACCOUNT' , --DETERMINING_FACTOR_CODE1 ----Bug 5247466
9282: 'ACCOUNT' ,--TAX_PARAMETER_CODE1 ----Bug 5247466

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

9517: --check if ap_tax_recvry_rules_all.NAME || rates.TAX is more than 30 characters in length
9518:
9519: DECODE(SIGN(LENGTHB(RULES.NAME||RATES.TAX)-30),
9520: 1,
9521: SUBSTRB(RULES.NAME,1,24)||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_RULES_B_S'),
9522: RULES.NAME||RATES.TAX)
9523:
9524: ELSE -- else for GROUP BY CHECKING
9525: RULES.NAME

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

9633: --check if ap_tax_recvry_rules_all.NAME || rates.TAX is more than 30 characters in length
9634:
9635: DECODE(SIGN(LENGTHB(RULES.NAME||RATES.TAX)-30),
9636: 1,
9637: SUBSTRB(RULES.NAME,1,24)||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_RULES_B_S'),
9638: RULES.NAME||RATES.TAX)
9639:
9640: ELSE -- else for GROUP BY CHECKING
9641: RULES.NAME