APPS.JAI_AR_TRX_LINES_PKG dependencies on JAI_RGM_DEFINITIONS

Line 463: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

459: v_converted_rate Number := 1;
460: v_books_id Number;
461: v_gl_date Date;
462: ln_tcs_exists number;
463: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
464: ln_threshold_slab_id JAI_AP_TDS_THHOLD_SLABS.threshold_slab_id%type;
465: ln_threshold_tax_cat_id JAI_AP_TDS_THHOLD_TAXES.tax_category_id%type;
466: ld_gl_dist_date date;
467: v_service_type VARCHAR2(30);

Line 477: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS

473: where customer_trx_id = cp_customer_trx_id
474: and account_class = jai_constants.account_class_rec
475: and latest_rec_flag = jai_constants.yes;
476:
477: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS
478: SELECT REGIME_ID
479: FROM JAI_RGM_DEFINITIONS
480: WHERE REGIME_CODE = CP_REGIME_CODE;
481:

Line 479: FROM JAI_RGM_DEFINITIONS

475: and latest_rec_flag = jai_constants.yes;
476:
477: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS
478: SELECT REGIME_ID
479: FROM JAI_RGM_DEFINITIONS
480: WHERE REGIME_CODE = CP_REGIME_CODE;
481:
482: CURSOR GC_CHK_RGM_TAX_EXISTS(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE,
483: CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE,

Line 482: CURSOR GC_CHK_RGM_TAX_EXISTS(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE,

478: SELECT REGIME_ID
479: FROM JAI_RGM_DEFINITIONS
480: WHERE REGIME_CODE = CP_REGIME_CODE;
481:
482: CURSOR GC_CHK_RGM_TAX_EXISTS(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE,
483: CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE,
484: CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE) IS
485: SELECT COUNT(1)
486: FROM JAI_CMN_TAX_CTG_LINES CATL,