DBA Data[Home] [Help]

APPS.JAI_RCV_RCV_RTV_PKG dependencies on JAI_RGM_DEFINITIONS

Line 1386: from JAI_RGM_DEFINITIONS

1382: ); /*Added excise taxes by mmurtuza for bug 16101545. Also changed tax_types.tax_type to jtc.tax_type*/
1383:
1384: cursor c_jai_regimes(p_regime_code varchar2) is
1385: select regime_id
1386: from JAI_RGM_DEFINITIONS
1387: where regime_code = p_regime_code;
1388:
1389: cursor c_is_tax_type_in_regime(cp_regime_id number, cp_tax_type varchar2) is
1390: select attribute_code regime_tax_type

Line 3835: from JAI_RGM_DEFINITIONS

3831: ln_regime_recovery_interim number;
3832:
3833: cursor c_jai_regimes (p_regime_code varchar2)is
3834: select regime_id
3835: from JAI_RGM_DEFINITIONS
3836: where regime_code = p_regime_code;
3837:
3838: --added tax_type in cursor definition for bug # 6807023
3839: cursor c_ja_in_tax_amt_by_account

Line 3883: from JAI_RGM_DEFINITIONS jr,

3879: and nvl(jrtl.modvat_flag, 'N') = 'Y'
3880: and jrtl.tax_type in
3881: (
3882: select jrr.attribute_code
3883: from JAI_RGM_DEFINITIONS jr,
3884: JAI_RGM_REGISTRATIONS jrr
3885: where jr.regime_id = jrr.regime_id
3886: and jr.regime_code = p_regime_code
3887: and jrr.registration_type = jai_constants.regn_type_tax_types