APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on STANDARD

Line 3001: 'STANDARD' , --STATUS_RESULT , --Bug 5385949

2997: 'CODE' , --RESULT_TYPE_CODE , --Bug 5385949
2998: NULL , --TAX_STATUS_CODE ,
2999: NULL , --NUMERIC_RESULT ,
3000: 'APPLICABLE' , --ALPHANUMERIC_RESULT ,
3001: 'STANDARD' , --STATUS_RESULT , --Bug 5385949
3002: RATE_RESULT ,
3003: NULL , --LEGAL_MESSAGE_CODE ,
3004: NULL , --MIN_TAX_AMT ,
3005: NULL , --MAX_TAX_AMT ,

Line 3042: decode(vat.leasing_flag,'Y',vat.tax_code,'STANDARD') RATE_RESULT

3038: CONDITION_GROUP_ID,
3039: rules.tax_rule_id TAX_RULE_ID ,
3040: NULL CONDITION_SET_ID ,
3041: NULL EXCEPTION_SET_ID ,
3042: decode(vat.leasing_flag,'Y',vat.tax_code,'STANDARD') RATE_RESULT
3043: FROM ZX_TAXES_B TAXES,
3044: ZX_CONDITION_GROUPS_B CG,
3045: ZX_PARTY_TAX_PROFILE PTP,
3046: AR_VAT_TAX_ALL_B VAT ,

Line 3079: and rate_result = decode(vat.leasing_flag,'Y',vat.tax_code,'STANDARD')

3075: AND not exists (select 1 from zx_process_results where
3076: tax_rule_id = rules.tax_rule_id
3077: and condition_group_code = cg.condition_group_code
3078: and result_type_code ='CODE' --Bug 5385949
3079: and rate_result = decode(vat.leasing_flag,'Y',vat.tax_code,'STANDARD')
3080: )
3081: UNION ALL
3082: SELECT
3083: cond_groups.CONDITION_GROUP_CODE CONDITION_GROUP_CODE,