DBA Data[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on ZX_RATES_B

Line 730: FROM ZX_RATES_B rates,

726: FND_GLOBAL.CONC_LOGIN_ID,
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'

Line 1033: FROM ZX_RATES_B rates,

1029: zx_fc_types_reg_assoc_s.nextval,
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'

Line 3090: FROM ZX_RATES_B rates,

3086: zx_fc_types_reg_assoc_s.nextval,
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

Line 3532: FROM ZX_RATES_B rates,

3528: FND_GLOBAL.CONC_LOGIN_ID,
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)

Line 3758: FROM ZX_RATES_B rates,

3754: zx_fc_types_reg_assoc_s.NEXTVAL,
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

Line 4318: zx_rates_b rates,

4314:
4315: SELECT unique
4316: tax_regime_code
4317: FROM
4318: zx_rates_b rates,
4319: zx_party_tax_profile ptp
4320: WHERE
4321: rates.content_owner_id = ptp.party_tax_profile_id and
4322: ptp.party_type_code = 'OU' and

Line 4908: FROM ZX_RATES_B rates,

4904: FND_GLOBAL.CONC_LOGIN_ID,
4905: zx_fc_types_reg_assoc_s.nextval,
4906: 1)
4907: SELECT unique rates.tax_regime_code
4908: FROM ZX_RATES_B rates,
4909: AR_VAT_TAX_ALL_B codes
4910: WHERE codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id) and
4911: codes.leasing_flag = 'Y' and
4912: rates.record_type_code = 'MIGRATED' and