APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 1423: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE; -- := 'N'; --Ramananda for File.Sql.35

1419: lv_rg23c_cess_avlbl VARCHAR2(10);
1420: lv_pla_cess_avlbl VARCHAR2(10);
1421: lv_vat_invoice_number JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
1422: lv_vat_taxes_exist VARCHAR2(1);
1423: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE; -- := 'N'; --Ramananda for File.Sql.35
1424: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
1425: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1426: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1427:

Line 2798: FROM jai_rgm_registrations

2794: /*
2795: CURSOR c_get_st_accrual_date (p_regime_id NUMBER)
2796: IS
2797: SELECT to_date(attribute_value, 'DD/MM/YYYY')
2798: FROM jai_rgm_registrations
2799: WHERE regime_id = p_regime_id
2800: AND attribute_code = 'EFF_DATE_ST_PT'
2801: AND attribute_type_code = 'OTHERS'
2802: AND registration_type = 'OTHERS';