APPS.JAI_MTL_TRXS_PKG dependencies on JAI_RGM_DEFINITIONS

Line 961: FROM jai_rgm_definitions

957:
958: --regime varchar2(100):=jai_constants.vat_regime;
959: CURSOR c_regime_cur IS
960: SELECT regime_id
961: FROM jai_rgm_definitions
962: WHERE regime_code = 'VAT';
963: /*added the below cursor for performance issue*/
964: --start
965: CURSOR c_chk_rgm_trxs(cp_transaction_header_id in number,cp_transaction_temp_id in number,cp_tax_id in number) IS

Line 998: jai_rgm_definitions jrr

994: jai_mtl_trxs jmt,
995: jai_cmn_document_taxes jcdt,
996: jai_cmn_taxes_all jtc,
997: jai_rgm_registrations jrg,
998: jai_rgm_definitions jrr
999: WHERE
1000: jmt.to_organization = p_organization_id
1001: AND jmt.location_id = p_location_id
1002: AND jmt.transaction_header_id = p_transaction_header_id

Line 1652: FROM jai_rgm_definitions

1648:
1649: stmt_name := 'Selecting regime id';
1650: SELECT regime_id
1651: INTO l_regime_id
1652: FROM jai_rgm_definitions
1653: WHERE regime_Code = 'VAT';
1654:
1655: stmt_name := 'Opening c_get_interorg_params';
1656: OPEN c_get_interorg_params(r_mtl_trx_info.from_organization, r_mtl_trx_info.to_organization) ;

Line 4703: FROM jai_rgm_definitions

4699: lv_process_status VARCHAR2(2);
4700: lv_process_message VARCHAR2(1000);
4701: CURSOR c_regime_cur IS
4702: SELECT regime_id
4703: FROM jai_rgm_definitions
4704: WHERE regime_code = 'VAT';
4705: stmt_name VARCHAR2(64);
4706: BEGIN
4707: OPEN c_regime_cur;

Line 5140: FROM jai_rgm_definitions

5136:
5137: CURSOR cur_regimes(cp_regime_code VARCHAR2)
5138: IS
5139: SELECT regime_id
5140: FROM jai_rgm_definitions
5141: WHERE regime_code = cp_regime_code;
5142:
5143: lv_accounting_type VARCHAR2(100);
5144: lv_account_nature VARCHAR2(100);

Line 5158: ln_regime_id jai_rgm_definitions.regime_id%TYPE;

5154: lv_destination VARCHAR2(10);
5155: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
5156: lv_process_status VARCHAR2(2);
5157: lv_process_message VARCHAR2(1000);
5158: ln_regime_id jai_rgm_definitions.regime_id%TYPE;
5159:
5160: rec_claims cur_claims%ROWTYPE;
5161:
5162: lv_reference_10 gl_interface.reference10%TYPE;