390: FETCH ORG_CUR
391: INTO V_ORG_ID;
392: CLOSE ORG_CUR;
393:
394: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
395: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur
396: INTO lv_tax_regime_code;
397: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
398:
391: INTO V_ORG_ID;
392: CLOSE ORG_CUR;
393:
394: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
395: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur
396: INTO lv_tax_regime_code;
397: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
398:
399: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
393:
394: OPEN jai_ar_trx_pkg.c_tax_regime_code_cur(V_ORG_ID);
395: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur
396: INTO lv_tax_regime_code;
397: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
398:
399: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
400: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur
401: INTO ln_tax_rate_id;
395: FETCH jai_ar_trx_pkg.c_tax_regime_code_cur
396: INTO lv_tax_regime_code;
397: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
398:
399: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
400: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur
401: INTO ln_tax_rate_id;
402: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur;
403:
396: INTO lv_tax_regime_code;
397: CLOSE jai_ar_trx_pkg.c_tax_regime_code_cur;
398:
399: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
400: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur
401: INTO ln_tax_rate_id;
402: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur;
403:
404: IF v_books_id IS NULL THEN
398:
399: OPEN jai_ar_trx_pkg.c_max_tax_rate_id_cur(lv_tax_regime_code);
400: FETCH jai_ar_trx_pkg.c_max_tax_rate_id_cur
401: INTO ln_tax_rate_id;
402: CLOSE jai_ar_trx_pkg.c_max_tax_rate_id_cur;
403:
404: IF v_books_id IS NULL THEN
405: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr(p_org_id => v_org_id);
406: v_books_id := l_func_curr_det.ledger_id;