DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 356: FROM RA_CUST_TRX_LINE_GL_DIST_ALL

352: And NVL(a.org_id,0) = NVL(pr_new.org_id,0);
353:
354: CURSOR gl_date_cur IS
355: SELECT DISTINCT gl_date
356: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
357: WHERE CUSTOMER_TRX_LINE_ID = v_prev_customer_trx_line_id;
358:
359: Cursor localization_line_info IS
360: Select assessable_value, tax_category_id, service_type_code --service_type_code added by csahoo for bug#5879769

Line 6271: from ra_cust_trx_line_gl_dist_all

6267:
6268: cursor c_gl_dist_date ( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type)
6269: is
6270: select gl_date
6271: from ra_cust_trx_line_gl_dist_all
6272: where customer_trx_id = cp_customer_trx_id
6273: and account_class = jai_constants.account_class_rec
6274: and latest_rec_flag = jai_constants.yes;
6275:

Line 6407: FROM RA_CUST_TRX_LINE_GL_DIST_ALL

6403: AND CUSTOMER_TRX_LINE_ID = pr_old.CUSTOMER_TRX_LINE_ID;
6404:
6405: CURSOR gl_date_cur IS
6406: SELECT DISTINCT gl_date
6407: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
6408: WHERE CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id;
6409:
6410:
6411: Cursor transaction_type_cur IS