APPS.AR_INVOICE_API_PUB dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 1615: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

1611: l_return_status VARCHAR2(10);
1612: l_trx_rec ra_customer_trx%rowtype;
1613: l_type_rec ra_cust_trx_types%rowtype;
1614: l_commitment_rec arp_process_commitment.commitment_rec_type;
1615: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1616: l_amount ra_cust_trx_line_gl_dist.amount%type;
1617: l_dummy BINARY_INTEGER;
1618: l_update_status VARCHAR2(50) := 'OK';
1619: l_delete_status VARCHAR2(50) := 'OK';

Line 1616: l_amount ra_cust_trx_line_gl_dist.amount%type;

1612: l_trx_rec ra_customer_trx%rowtype;
1613: l_type_rec ra_cust_trx_types%rowtype;
1614: l_commitment_rec arp_process_commitment.commitment_rec_type;
1615: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1616: l_amount ra_cust_trx_line_gl_dist.amount%type;
1617: l_dummy BINARY_INTEGER;
1618: l_update_status VARCHAR2(50) := 'OK';
1619: l_delete_status VARCHAR2(50) := 'OK';
1620: l_validation_status VARCHAR2(10);

Line 1704: FROM ra_cust_trx_line_gl_dist

1700: SELECT trunc(gl_date),
1701: amount
1702: INTO l_gl_date,
1703: l_amount
1704: FROM ra_cust_trx_line_gl_dist
1705: WHERE customer_trx_id = p_customer_trx_id
1706: AND account_class = 'REC'
1707: AND latest_rec_flag = 'Y';
1708: