APPS.ARP_PROCESS_DEBIT_MEMO dependencies on RA_CUSTOMER_TRX_LINES

Line 42: ra_customer_trx_lines.customer_trx_line_id%type,

38: +===========================================================================*/
39:
40: PROCEDURE line_post_insert (
41: p_customer_trx_line_id IN
42: ra_customer_trx_lines.customer_trx_line_id%type,
43: p_ccid1 IN
44: gl_code_combinations.code_combination_id%type,
45: p_ccid2 IN
46: gl_code_combinations.code_combination_id%type,

Line 58: l_extended_amount ra_customer_trx_lines.extended_amount%type;

54: l_cust_trx_line_gl_dist_id
55: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
56: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
57: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
58: l_extended_amount ra_customer_trx_lines.extended_amount%type;
59: l_exchange_rate ra_customer_trx.exchange_rate%type;
60:
61: BEGIN
62:

Line 80: ra_customer_trx_lines ctl

76: l_gl_date,
77: l_extended_amount
78: FROM ra_customer_trx ct,
79: ra_cust_trx_line_gl_dist lgd,
80: ra_customer_trx_lines ctl
81: WHERE ctl.customer_trx_line_id = p_customer_trx_line_id
82: AND ctl.customer_trx_id = ct.customer_trx_id
83: AND ctl.customer_trx_id = lgd.customer_trx_id
84: AND lgd.account_class = 'REC'