DBA Data[Home] [Help]

APPS.GL_JE_LINES_PKG dependencies on ZX_ACCOUNT_RATES

Line 413: FROM zx_account_rates rates

409: x_eff_date, NULL, NULL, p_date);
410:
411: SELECT max(decode(allow_rate_override_flag, 'N', 1, 0))
412: INTO dummy
413: FROM zx_account_rates rates
414: WHERE rates.ledger_id = x_ledger_id
415: AND rates.account_segment_value = x_account_num
416: AND rates.tax_class = 'NON_TAXABLE';
417:

Line 583: FROM zx_account_rates rates

579: sysdate, NULL, NULL, p_date);
580:
581: SELECT count(*), max(decode(rates.tax_class, 'INPUT', 'I', 'OUTPUT', 'O', NULL, 'T'))
582: INTO num_defaults, default_tax_type_code
583: FROM zx_account_rates rates
584: WHERE rates.ledger_id = x_ledger_id
585: AND rates.account_segment_value = x_account_value
586: AND nvl(rates.tax_class,'T') <> 'NON_TAXABLE';
587: