APPS.AR_INVOICE_API_PUB dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 1682: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

1678: l_return_status VARCHAR2(10);
1679: l_trx_rec ra_customer_trx%rowtype;
1680: l_type_rec ra_cust_trx_types%rowtype;
1681: l_commitment_rec arp_process_commitment.commitment_rec_type;
1682: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1683: l_amount ra_cust_trx_line_gl_dist.amount%type;
1684: l_dummy BINARY_INTEGER;
1685: l_update_status VARCHAR2(50) := 'OK';
1686: l_delete_status VARCHAR2(50) := 'OK';

Line 1683: l_amount ra_cust_trx_line_gl_dist.amount%type;

1679: l_trx_rec ra_customer_trx%rowtype;
1680: l_type_rec ra_cust_trx_types%rowtype;
1681: l_commitment_rec arp_process_commitment.commitment_rec_type;
1682: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1683: l_amount ra_cust_trx_line_gl_dist.amount%type;
1684: l_dummy BINARY_INTEGER;
1685: l_update_status VARCHAR2(50) := 'OK';
1686: l_delete_status VARCHAR2(50) := 'OK';
1687: l_validation_status VARCHAR2(10);

Line 1771: FROM ra_cust_trx_line_gl_dist

1767: SELECT trunc(gl_date),
1768: amount
1769: INTO l_gl_date,
1770: l_amount
1771: FROM ra_cust_trx_line_gl_dist
1772: WHERE customer_trx_id = p_customer_trx_id
1773: AND account_class = 'REC'
1774: AND latest_rec_flag = 'Y';
1775: