APPS.JAI_AR_TRX_LINES_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 81: FROM RA_CUST_TRX_LINE_GL_DIST_ALL

77: AND NVL(a.org_id, 0) = NVL(pr_new.org_id, 0);
78:
79: CURSOR gl_date_cur IS
80: SELECT DISTINCT gl_date
81: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
82: WHERE CUSTOMER_TRX_LINE_ID = v_prev_customer_trx_line_id;
83:
84: CURSOR localization_line_info IS
85: SELECT assessable_value, tax_category_id, service_type_code

Line 472: from ra_cust_trx_line_gl_dist_all

468: v_num_check Number;
469:
470: cursor c_gl_dist_date(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type) is
471: select gl_date
472: from ra_cust_trx_line_gl_dist_all
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:

Line 576: FROM RA_CUST_TRX_LINE_GL_DIST_ALL

572: AND CUSTOMER_TRX_LINE_ID = pr_old.CUSTOMER_TRX_LINE_ID;
573:
574: CURSOR gl_date_cur IS
575: SELECT DISTINCT gl_date
576: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
577: WHERE CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id;
578:
579: Cursor transaction_type_cur IS
580: Select a.type