APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 330: FROM RA_CUST_TRX_LINE_GL_DIST_ALL

326: And NVL(a.org_id,0) = NVL(pr_new.org_id,0);
327:
328: CURSOR gl_date_cur IS
329: SELECT DISTINCT gl_date
330: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
331: WHERE CUSTOMER_TRX_LINE_ID = v_prev_customer_trx_line_id;
332:
333: Cursor localization_line_info IS
334: Select assessable_value, tax_category_id, service_type_code --service_type_code added by csahoo for bug#5879769

Line 4899: from ra_cust_trx_line_gl_dist_all

4895:
4896: cursor c_gl_dist_date ( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type)
4897: is
4898: select gl_date
4899: from ra_cust_trx_line_gl_dist_all
4900: where customer_trx_id = cp_customer_trx_id
4901: and account_class = jai_constants.account_class_rec
4902: and latest_rec_flag = jai_constants.yes;
4903:

Line 5027: FROM RA_CUST_TRX_LINE_GL_DIST_ALL

5023: AND CUSTOMER_TRX_LINE_ID = pr_old.CUSTOMER_TRX_LINE_ID;
5024:
5025: CURSOR gl_date_cur IS
5026: SELECT DISTINCT gl_date
5027: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
5028: WHERE CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id;
5029:
5030:
5031: Cursor transaction_type_cur IS