APPS.JAI_MTL_TRXS_PKG dependencies on JAI_RGM_DEFINITIONS

Line 838: FROM jai_rgm_definitions

834:
835: --regime varchar2(100):=jai_constants.vat_regime;
836: CURSOR c_regime_cur IS
837: SELECT regime_id
838: FROM jai_rgm_definitions
839: WHERE regime_code = 'VAT';
840: /*added the below cursor for performance issue*/
841: --start
842: CURSOR c_chk_rgm_trxs(cp_transaction_header_id in number,cp_transaction_temp_id in number,cp_tax_id in number) IS

Line 875: jai_rgm_definitions jrr

871: jai_mtl_trxs jmt,
872: jai_cmn_document_taxes jcdt,
873: jai_cmn_taxes_all jtc,
874: jai_rgm_registrations jrg,
875: jai_rgm_definitions jrr
876: WHERE
877: jmt.to_organization = p_organization_id
878: AND jmt.location_id = p_location_id
879: AND jmt.transaction_header_id = p_transaction_header_id

Line 1524: FROM jai_rgm_definitions

1520:
1521: stmt_name := 'Selecting regime id';
1522: SELECT regime_id
1523: INTO l_regime_id
1524: FROM jai_rgm_definitions
1525: WHERE regime_Code = 'VAT';
1526:
1527: stmt_name := 'Opening c_get_interorg_params';
1528: OPEN c_get_interorg_params(r_mtl_trx_info.from_organization, r_mtl_trx_info.to_organization) ;

Line 4263: FROM jai_rgm_definitions

4259: lv_process_status VARCHAR2(2);
4260: lv_process_message VARCHAR2(1000);
4261: CURSOR c_regime_cur IS
4262: SELECT regime_id
4263: FROM jai_rgm_definitions
4264: WHERE regime_code = 'VAT';
4265: stmt_name VARCHAR2(64);
4266: BEGIN
4267: OPEN c_regime_cur;

Line 4697: FROM jai_rgm_definitions

4693:
4694: CURSOR cur_regimes(cp_regime_code VARCHAR2)
4695: IS
4696: SELECT regime_id
4697: FROM jai_rgm_definitions
4698: WHERE regime_code = cp_regime_code;
4699:
4700: lv_accounting_type VARCHAR2(100);
4701: lv_account_nature VARCHAR2(100);

Line 4715: ln_regime_id jai_rgm_definitions.regime_id%TYPE;

4711: lv_destination VARCHAR2(10);
4712: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
4713: lv_process_status VARCHAR2(2);
4714: lv_process_message VARCHAR2(1000);
4715: ln_regime_id jai_rgm_definitions.regime_id%TYPE;
4716:
4717: rec_claims cur_claims%ROWTYPE;
4718:
4719: lv_reference_10 gl_interface.reference10%TYPE;