APPS.ARP_BILLS_RECEIVABLE_MAIN dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 2379: | from table ra_cust_trx_line_gl_dist |

2375:
2376:
2377: /*--------------------------------------------------+
2378: | Cursor for the accounting on normal transactions |
2379: | from table ra_cust_trx_line_gl_dist |
2380: +--------------------------------------------------*/
2381: CURSOR TRX_exchange_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
2382: SELECT dist.code_combination_id
2383: FROM ra_cust_trx_line_gl_dist dist

Line 2383: FROM ra_cust_trx_line_gl_dist dist

2379: | from table ra_cust_trx_line_gl_dist |
2380: +--------------------------------------------------*/
2381: CURSOR TRX_exchange_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
2382: SELECT dist.code_combination_id
2383: FROM ra_cust_trx_line_gl_dist dist
2384: WHERE dist.customer_trx_id = l_customer_trx_id
2385: AND dist.account_class = C_REC
2386: AND dist.latest_rec_flag = 'Y';
2387:

Line 2523: | from table ra_cust_trx_line_gl_dist. |

2519: IF all_exchanges_rec.cnt_br_ref_trx_id = all_exchanges_rec.source_trx_id THEN
2520:
2521: /*--------------------------------------------------+
2522: | If exchanges transaction is not BR fetch account |
2523: | from table ra_cust_trx_line_gl_dist. |
2524: +--------------------------------------------------*/
2525: IF l_current_trx_id <> all_exchanges_rec.source_trx_id THEN
2526:
2527: OPEN TRX_exchange_cur(all_exchanges_rec.source_trx_id);