DBA Data[Home] [Help]

APPS.ZX_VALIDATE_API_PKG dependencies on ZX_REGIMES_B

Line 2014: ZX_REGIMES_B regime ,

2010: lines_gt.trx_line_id,
2011: lines_gt.trx_level_type,
2012: taxlines_gt.summary_tax_line_number
2013: FROM ZX_TRX_HEADERS_GT header,
2014: ZX_REGIMES_B regime ,
2015: ZX_TAXES_B tax ,
2016: ZX_STATUS_B status ,
2017: -- ZX_RATES_B rate ,
2018: -- zx_rates_b off_rate,

Line 2104: FROM zx_regimes_b

2100: /* OR regime.effective_from =
2101: (
2102: SELECT
2103: MIN(effective_from)
2104: FROM zx_regimes_b
2105: WHERE tax_regime_code = regime.tax_regime_code
2106: ) */
2107: )
2108: --* for taxes

Line 5423: ZX_REGIMES_B regime ,

5419: END ZX_IMP_TAX_RATE_AMT_MISMATCH
5420:
5421: /* end bug 3676878 */
5422: FROM ZX_TRX_HEADERS_GT header,
5423: ZX_REGIMES_B regime ,
5424: ZX_TAXES_B tax ,
5425: ZX_STATUS_B status ,
5426: -- ZX_RATES_B rate ,
5427: -- zx_rates_b off_rate,

Line 5514: FROM zx_regimes_b

5510: /* OR regime.effective_from =
5511: (
5512: SELECT
5513: MIN(effective_from)
5514: FROM zx_regimes_b
5515: WHERE tax_regime_code = regime.tax_regime_code
5516: ) */
5517: )
5518: --* for taxes

Line 7494: ZX_REGIMES_B regime ,

7490: from
7491: zx_trx_headers_gt header,
7492: --zx_transaction_lines_gt lines_gt,
7493: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
7494: ZX_REGIMES_B regime ,
7495: ZX_TAXES_B tax ,
7496: ZX_STATUS_B status ,
7497: zx_subscription_details sd_reg,
7498: zx_subscription_details sd_tax,