DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_RULES_B_S

Line 9795: zx_rules_b_s.nextval ,--TAX_RULE_ID

9791: 'Y' ,--ENABLED_FLAG
9792: 'MIGRATED' ,--RECORD_TYPE_CODE
9793: 'EX Acct String Range-Party FC' ,--DET_FACTOR_TEMPL_CODE
9794: CONTENT_OWNER_ID ,
9795: zx_rules_b_s.nextval ,--TAX_RULE_ID
9796: fnd_global.user_id ,
9797: SYSDATE ,
9798: fnd_global.user_id ,
9799: SYSDATE ,

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

9902: 'Y' ,--ENABLED_FLAG
9903: 'MIGRATED' ,--RECORD_TYPE_CODE
9904: 'EX Acct String Range-Party FC' ,--DET_FACTOR_TEMPL_CODE
9905: CONTENT_OWNER_ID ,
9906: zx_rules_b_s.nextval ,--TAX_RULE_ID
9907: fnd_global.user_id ,
9908: SYSDATE ,
9909: fnd_global.user_id ,
9910: SYSDATE ,

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