APPS.ARP_PROCESS_DEBIT_MEMO dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 48: ra_cust_trx_line_gl_dist.amount%type,

44: gl_code_combinations.code_combination_id%type,
45: p_ccid2 IN
46: gl_code_combinations.code_combination_id%type,
47: p_amount1 IN
48: ra_cust_trx_line_gl_dist.amount%type,
49: p_amount2 IN
50: ra_cust_trx_line_gl_dist.amount%type )
51: IS
52:

Line 50: ra_cust_trx_line_gl_dist.amount%type )

46: gl_code_combinations.code_combination_id%type,
47: p_amount1 IN
48: ra_cust_trx_line_gl_dist.amount%type,
49: p_amount2 IN
50: ra_cust_trx_line_gl_dist.amount%type )
51: IS
52:
53: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
54: l_cust_trx_line_gl_dist_id

Line 53: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;

49: p_amount2 IN
50: ra_cust_trx_line_gl_dist.amount%type )
51: IS
52:
53: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
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;

Line 55: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;

51: IS
52:
53: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
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;

Line 57: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

53: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
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

Line 79: ra_cust_trx_line_gl_dist lgd,

75: l_exchange_rate,
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