APPS.JAI_AR_TRX_HEADERS_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 1577: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;

1573: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1574: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1575: lv_process_flag VARCHAR2(10);
1576: lv_process_message VARCHAR2(4000);
1577: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
1578: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE;
1579:
1580: CURSOR organization_cur IS
1581: SELECT organization_id, location_id, vat_invoice_no, vat_invoice_date

Line 1604: CURSOR cur_get_gl_date(cp_acct_class ra_cust_trx_line_gl_dist_all.account_class%type) IS

1600: AND jtc.tax_type = jrttv.tax_type
1601: AND regime_code = jai_constants.vat_regime
1602: AND jtc.org_id = pr_new.org_id;
1603:
1604: CURSOR cur_get_gl_date(cp_acct_class ra_cust_trx_line_gl_dist_all.account_class%type) IS
1605: SELECT gl_date
1606: FROM ra_cust_trx_line_gl_dist_all
1607: WHERE customer_trx_id = pr_new.customer_trx_id
1608: AND account_class = cp_acct_class

Line 1606: FROM ra_cust_trx_line_gl_dist_all

1602: AND jtc.org_id = pr_new.org_id;
1603:
1604: CURSOR cur_get_gl_date(cp_acct_class ra_cust_trx_line_gl_dist_all.account_class%type) IS
1605: SELECT gl_date
1606: FROM ra_cust_trx_line_gl_dist_all
1607: WHERE customer_trx_id = pr_new.customer_trx_id
1608: AND account_class = cp_acct_class
1609: AND latest_rec_flag = 'Y';
1610:

Line 2176: CURSOR cur_get_gl_date(cp_account_class ra_cust_trx_line_gl_dist_all.account_class%type) IS

2172: SELECT excise_invoice_no
2173: FROM JAI_AR_TRX_LINES
2174: WHERE customer_trx_id = pr_new.customer_trx_id;
2175:
2176: CURSOR cur_get_gl_date(cp_account_class ra_cust_trx_line_gl_dist_all.account_class%type) IS
2177: SELECT gl_date
2178: FROM ra_cust_trx_line_gl_dist_all
2179: WHERE customer_trx_id = pr_new.customer_trx_id
2180: AND account_class = cp_account_class

Line 2178: FROM ra_cust_trx_line_gl_dist_all

2174: WHERE customer_trx_id = pr_new.customer_trx_id;
2175:
2176: CURSOR cur_get_gl_date(cp_account_class ra_cust_trx_line_gl_dist_all.account_class%type) IS
2177: SELECT gl_date
2178: FROM ra_cust_trx_line_gl_dist_all
2179: WHERE customer_trx_id = pr_new.customer_trx_id
2180: AND account_class = cp_account_class
2181: AND latest_rec_flag = 'Y';
2182:

Line 2194: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;

2190: lv_pla_cess_avlbl VARCHAR2(10);
2191: lv_vat_invoice_number JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
2192: lv_vat_taxes_exist VARCHAR2(1);
2193: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
2194: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
2195: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
2196: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
2197:
2198: lv_doc_type_class varchar2(2);