APPS.JAI_AR_TRX_HEADERS_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 2164: FROM JAI_RGM_ORG_REGNS_V

2160:
2161: CURSOR cur_get_same_inv_no(cp_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE,
2162: cp_location_id JAI_AR_TRXS.LOCATION_ID%TYPE) IS
2163: SELECT nvl(attribute_value, 'N') attribute_value
2164: FROM JAI_RGM_ORG_REGNS_V
2165: WHERE regime_code = jai_constants.vat_regime
2166: AND attribute_type_code = jai_constants.regn_type_others
2167: AND attribute_code = jai_constants.attr_code_same_inv_no
2168: AND organization_id = cp_organization_id

Line 2201: lv_cgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;

2197:
2198: lv_doc_type_class varchar2(2);
2199: ln_cgst_regime_id NUMBER;
2200: ln_sgst_regime_id NUMBER;
2201: lv_cgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
2202: lv_sgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
2203:
2204: cursor c_get_rec(cn_customer_trx_id number) is
2205: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;

Line 2202: lv_sgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;

2198: lv_doc_type_class varchar2(2);
2199: ln_cgst_regime_id NUMBER;
2200: ln_sgst_regime_id NUMBER;
2201: lv_cgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
2202: lv_sgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
2203:
2204: cursor c_get_rec(cn_customer_trx_id number) is
2205: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;
2206: