DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on AP_TAX_CODES_ALL

Line 679: ap_tax_codes_all codes --Bug 5061471

675: codes.name
676: ALPHANUMERIC_VALUE1 ,
677: NULL CONSTRAINT_ID
678: FROM
679: ap_tax_codes_all codes --Bug 5061471
680: WHERE
681: codes.tax_type = 'TAX_GROUP'
682: AND codes.name = nvl(p_name,codes.name);
683:

Line 2525: AP_TAX_CODES_ALL codes

2521: ZX_RATES_B rates,
2522: FND_LOOKUPS fnd,
2523: ZX_RULES_B rules,
2524: ZX_CONDITION_GROUPS_B cond_groups,
2525: AP_TAX_CODES_ALL codes
2526: WHERE
2527: rates.record_type_code = 'MIGRATED'
2528: AND nvl(rates.source_id, rates.tax_rate_id) = codes.tax_id
2529: AND rates.tax_rate_code = fnd.lookup_code

Line 2563: AP_TAX_CODES_ALL GROUP_CODES,

2559: cond_groups.CONDITION_GROUP_ID CONDITION_GROUP_ID ,
2560: rules.TAX_RULE_ID TAX_RULE_ID
2561: FROM
2562: AR_TAX_GROUP_CODES_ALL GROUPS,
2563: AP_TAX_CODES_ALL GROUP_CODES,
2564: AP_TAX_CODES_ALL CODES,
2565: ZX_RATES_B rates,
2566: ZX_RULES_B rules,
2567: ZX_CONDITION_GROUPS_B cond_groups

Line 2564: AP_TAX_CODES_ALL CODES,

2560: rules.TAX_RULE_ID TAX_RULE_ID
2561: FROM
2562: AR_TAX_GROUP_CODES_ALL GROUPS,
2563: AP_TAX_CODES_ALL GROUP_CODES,
2564: AP_TAX_CODES_ALL CODES,
2565: ZX_RATES_B rates,
2566: ZX_RULES_B rules,
2567: ZX_CONDITION_GROUPS_B cond_groups
2568: WHERE