DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on AP_TAX_CODES_ALL

Line 684: ap_tax_codes_all codes --Bug 5061471

680: codes.name
681: ALPHANUMERIC_VALUE1 ,
682: NULL CONSTRAINT_ID
683: FROM
684: ap_tax_codes_all codes --Bug 5061471
685: WHERE
686: codes.tax_type = 'TAX_GROUP'
687: AND codes.name = nvl(p_name,codes.name);
688:

Line 2691: AP_TAX_CODES_ALL codes

2687: ZX_RATES_B rates,
2688: FND_LOOKUPS fnd,
2689: ZX_RULES_B rules,
2690: ZX_CONDITION_GROUPS_B cond_groups,
2691: AP_TAX_CODES_ALL codes
2692: WHERE
2693: rates.record_type_code = 'MIGRATED'
2694: AND nvl(rates.source_id, rates.tax_rate_id) = codes.tax_id
2695: AND rates.tax_rate_code = fnd.lookup_code

Line 2730: AP_TAX_CODES_ALL GROUP_CODES,

2726: cond_groups.CONDITION_GROUP_ID CONDITION_GROUP_ID ,
2727: rules.TAX_RULE_ID TAX_RULE_ID
2728: FROM
2729: AR_TAX_GROUP_CODES_ALL GROUPS,
2730: AP_TAX_CODES_ALL GROUP_CODES,
2731: AP_TAX_CODES_ALL CODES,
2732: ZX_RATES_B rates,
2733: ZX_RULES_B rules,
2734: ZX_CONDITION_GROUPS_B cond_groups

Line 2731: AP_TAX_CODES_ALL CODES,

2727: rules.TAX_RULE_ID TAX_RULE_ID
2728: FROM
2729: AR_TAX_GROUP_CODES_ALL GROUPS,
2730: AP_TAX_CODES_ALL GROUP_CODES,
2731: AP_TAX_CODES_ALL CODES,
2732: ZX_RATES_B rates,
2733: ZX_RULES_B rules,
2734: ZX_CONDITION_GROUPS_B cond_groups
2735: WHERE