APPS.ARP_BILLS_RECEIVABLE_MAIN dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 2372: | from table ra_cust_trx_line_gl_dist |

2368:
2369:
2370: /*--------------------------------------------------+
2371: | Cursor for the accounting on normal transactions |
2372: | from table ra_cust_trx_line_gl_dist |
2373: +--------------------------------------------------*/
2374: CURSOR TRX_exchange_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
2375: SELECT dist.code_combination_id
2376: FROM ra_cust_trx_line_gl_dist dist

Line 2376: FROM ra_cust_trx_line_gl_dist dist

2372: | from table ra_cust_trx_line_gl_dist |
2373: +--------------------------------------------------*/
2374: CURSOR TRX_exchange_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS
2375: SELECT dist.code_combination_id
2376: FROM ra_cust_trx_line_gl_dist dist
2377: WHERE dist.customer_trx_id = l_customer_trx_id
2378: AND dist.account_class = C_REC
2379: AND dist.latest_rec_flag = 'Y';
2380:

Line 2516: | from table ra_cust_trx_line_gl_dist. |

2512: IF NVL(all_exchanges_rec.class,'INV') <> 'BR' THEN
2513:
2514: /*--------------------------------------------------+
2515: | If exchanges transaction is not BR fetch account |
2516: | from table ra_cust_trx_line_gl_dist. |
2517: +--------------------------------------------------*/
2518: IF l_current_trx_id <> all_exchanges_rec.source_trx_id THEN
2519:
2520: OPEN TRX_exchange_cur(all_exchanges_rec.source_trx_id);