DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_RULES_B_S

Line 9497: zx_rules_b_s.nextval ,--TAX_RULE_ID

9493: 'Y' ,--ENABLED_FLAG
9494: 'MIGRATED' ,--RECORD_TYPE_CODE
9495: 'EX Acct String Range-Party FC' ,--DET_FACTOR_TEMPL_CODE
9496: CONTENT_OWNER_ID ,
9497: zx_rules_b_s.nextval ,--TAX_RULE_ID
9498: fnd_global.user_id ,
9499: SYSDATE ,
9500: fnd_global.user_id ,
9501: SYSDATE ,

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 9613: zx_rules_b_s.nextval ,--TAX_RULE_ID

9609: 'Y' ,--ENABLED_FLAG
9610: 'MIGRATED' ,--RECORD_TYPE_CODE
9611: 'EX Acct String Range-Party FC' ,--DET_FACTOR_TEMPL_CODE
9612: CONTENT_OWNER_ID ,
9613: zx_rules_b_s.nextval ,--TAX_RULE_ID
9614: fnd_global.user_id ,
9615: SYSDATE ,
9616: fnd_global.user_id ,
9617: SYSDATE ,

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