APPS.PA_INVOICE_TIEBACK dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 31: from ra_cust_trx_line_gl_dist_all tgl,

27: Is
28: /* Commented the code change done for bug 4022244 and modified the previous
29: query as below for this bug 6443623 */
30: Select sum(tgl.acctd_amount)
31: from ra_cust_trx_line_gl_dist_all tgl,
32: ra_customer_trx_lines trx
33: where trx.customer_trx_id = l_cust_trx_id
34: and trim(trx.interface_line_attribute6)
35: = to_char(l_line_num)

Line 43: from ra_cust_trx_line_gl_dist_all tgl,

39:
40: /* Bug 4022244. Modified the cursor query to add a new join for interface_line_context */
41: /* Commenting the code for Bug 6443623
42: Select sum(tgl.acctd_amount)
43: from ra_cust_trx_line_gl_dist_all tgl,
44: ra_customer_trx_lines trx_lines,
45: ra_customer_trx trx, ra_batch_sources source
46: where trx_lines.customer_trx_id = trx.customer_trx_id
47: and trx.batch_source_id = source.batch_source_id

Line 58: from ra_cust_trx_line_gl_dist_all tgl,

54: and tgl.account_class = 'REV';
55: */
56: /* Commenting the following for bug 4022244.
57: Select sum(tgl.acctd_amount)
58: from ra_cust_trx_line_gl_dist_all tgl,
59: ra_customer_trx_lines trx
60: where trx.customer_trx_id = l_cust_trx_id
61: and to_number(trunc(trx.interface_line_attribute6))
62: = l_line_num