DBA Data[Home] [Help]

APPS.JAI_RCV_RCV_RTV_PKG dependencies on JAI_RGM_DEFINITIONS

Line 1219: from JAI_RGM_DEFINITIONS

1215: AND NVL(jtc.inclusive_tax_flag,'N')='N'; --add by eric for inclusive tax,picking the exclusive tax only
1216:
1217: cursor c_jai_regimes(p_regime_code varchar2) is
1218: select regime_id
1219: from JAI_RGM_DEFINITIONS
1220: where regime_code = p_regime_code;
1221:
1222: cursor c_is_tax_type_in_regime(cp_regime_id number, cp_tax_type varchar2) is
1223: select attribute_code regime_tax_type

Line 2904: from JAI_RGM_DEFINITIONS

2900: ln_regime_recovery_interim number;
2901:
2902: cursor c_jai_regimes (p_regime_code varchar2)is
2903: select regime_id
2904: from JAI_RGM_DEFINITIONS
2905: where regime_code = p_regime_code;
2906:
2907: --added tax_type in cursor definition for bug # 6807023
2908: cursor c_ja_in_tax_amt_by_account

Line 2952: from JAI_RGM_DEFINITIONS jr,

2948: and nvl(jrtl.modvat_flag, 'N') = 'Y'
2949: and jrtl.tax_type in
2950: (
2951: select jrr.attribute_code
2952: from JAI_RGM_DEFINITIONS jr,
2953: JAI_RGM_REGISTRATIONS jrr
2954: where jr.regime_id = jrr.regime_id
2955: and jr.regime_code = p_regime_code
2956: and jrr.registration_type = jai_constants.regn_type_tax_types