APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 246: FROM ra_cust_trx_line_gl_dist_all

242: WHERE invoice_distribution_id = pn_source_document_id;
243:
244: CURSOR get_ar_dist_date_cur IS
245: SELECT gl_date
246: FROM ra_cust_trx_line_gl_dist_all
247: WHERE customer_trx_id = pn_document_id
248: AND account_class = 'REV';
249:
250: /*Bug 12805386 - Fetch Effective Date of Point of Taxation only if Organization Type is either 'INDIVIDUALS' or 'PARTNERSHIP FIRM'

Line 2191: FROM ra_cust_trx_line_gl_dist_all rda,

2187: AND invoice_line_number = cp_line_num;
2188:
2189: CURSOR get_ar_gl_date_cur IS
2190: SELECT rda.gl_date
2191: FROM ra_cust_trx_line_gl_dist_all rda,
2192: ra_customer_trx_lines_all rla
2193: WHERE rda.customer_trx_id = p_document_id
2194: AND rda.account_class = 'REV'
2195: AND rda.customer_trx_line_id = rla.customer_trx_line_id