DBA Data[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on ZX_RATES_B

Line 717: FROM ZX_RATES_B rates,

713: FND_GLOBAL.CONC_LOGIN_ID,
714: zx_fc_types_reg_assoc_s.nextval,
715: 1)
716: SELECT unique tax_regime_code
717: FROM ZX_RATES_B rates,
718: AP_TAX_CODES_ALL codes
719: WHERE
720: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) and
721: codes.global_attribute_category = 'JE.HU.APXTADTC.TAX_ORIGIN' and

Line 1022: FROM ZX_RATES_B rates,

1018: zx_fc_types_reg_assoc_s.nextval,
1019: 1)
1020: SELECT
1021: unique tax_regime_code
1022: FROM ZX_RATES_B rates,
1023: AP_TAX_CODES_ALL codes
1024: WHERE
1025: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) and
1026: codes.global_attribute_category = 'JL.BR.INVIDITM.AR.Fiscal' and

Line 3059: FROM ZX_RATES_B rates,

3055: zx_fc_types_reg_assoc_s.nextval,
3056: 1)
3057: Select unique
3058: tax_regime_code
3059: FROM ZX_RATES_B rates,
3060: AP_TAX_CODES_ALL codes
3061: WHERE
3062: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) and
3063: codes.global_attribute_category = p_global_attribute_category and

Line 3559: FROM ZX_RATES_B rates,

3555: zx_fc_types_reg_assoc_s.NEXTVAL,
3556: 1)
3557: SELECT
3558: unique tax_regime_code
3559: FROM ZX_RATES_B rates,
3560: AP_TAX_CODES_ALL codes
3561: WHERE
3562: codes.tax_id = nvl(rates.source_id, rates.tax_rate_id) and
3563: codes.global_attribute_category = 'JE.PL.APXTADTC.TAX_ORIGIN' and

Line 4117: zx_rates_b rates,

4113:
4114: SELECT unique
4115: tax_regime_code
4116: FROM
4117: zx_rates_b rates,
4118: zx_party_tax_profile ptp
4119: WHERE
4120: rates.content_owner_id = ptp.party_tax_profile_id and
4121: ptp.party_type_code = 'OU' and

Line 4684: FROM ZX_RATES_B rates,

4680: FND_GLOBAL.CONC_LOGIN_ID,
4681: zx_fc_types_reg_assoc_s.nextval,
4682: 1)
4683: SELECT unique rates.tax_regime_code
4684: FROM ZX_RATES_B rates,
4685: AR_VAT_TAX_ALL_B codes
4686: WHERE codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id) and
4687: codes.leasing_flag = 'Y' and
4688: rates.record_type_code = 'MIGRATED' and