APPS.ZX_FC_MIGRATE_PKG dependencies on AP_TAX_CODES_ALL

Line 731: AP_TAX_CODES_ALL codes

727: zx_fc_types_reg_assoc_s.nextval,
728: 1)
729: SELECT unique tax_regime_code
730: FROM ZX_RATES_B rates,
731: AP_TAX_CODES_ALL codes
732: WHERE codes.tax_id = nvl(rates.source_id, rates.tax_rate_id)
733: and codes.global_attribute_category = 'JE.HU.APXTADTC.TAX_ORIGIN'
734: and rates.record_type_code = 'MIGRATED'
735: and not exists

Line 1034: AP_TAX_CODES_ALL codes

1030: 1)
1031: SELECT
1032: unique tax_regime_code
1033: FROM ZX_RATES_B rates,
1034: AP_TAX_CODES_ALL codes
1035: WHERE codes.tax_id = nvl(rates.source_id, rates.tax_rate_id)
1036: and codes.global_attribute_category = 'JL.BR.INVIDITM.AR.Fiscal'
1037: and rates.record_type_code = 'MIGRATED'
1038: and not exists

Line 3091: AP_TAX_CODES_ALL codes

3087: 1)
3088: Select unique
3089: tax_regime_code
3090: FROM ZX_RATES_B rates,
3091: AP_TAX_CODES_ALL codes
3092: WHERE
3093: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) and
3094: codes.global_attribute_category = p_global_attribute_category and
3095: rates.record_type_code = 'MIGRATED' and

Line 3533: ap_tax_codes_all codes,

3529: zx_fc_types_reg_assoc_s.nextval,
3530: 1)
3531: SELECT unique rates.tax_regime_code
3532: FROM ZX_RATES_B rates,
3533: ap_tax_codes_all codes,
3534: ap_tax_recvry_rates_all rec_rates,
3535: ap_tax_recvry_rules_all rules
3536: WHERE codes.tax_id = nvl(rates.source_id, rates.tax_rate_id)
3537: and rates.record_type_code = 'MIGRATED'

Line 3759: AP_TAX_CODES_ALL codes

3755: 1)
3756: SELECT
3757: unique tax_regime_code
3758: FROM ZX_RATES_B rates,
3759: AP_TAX_CODES_ALL codes
3760: WHERE
3761: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) and
3762: codes.global_attribute_category = 'JE.PL.APXTADTC.TAX_ORIGIN' and
3763: rates.record_type_code = 'MIGRATED' and