[Home] [Help]
APPS.OKS_ARFETCH_PUB dependencies on RA_CUSTOMER_TRX_LINES_ALL
Line 204: FROM RA_CUSTOMER_TRX_LINES_ALL CTL
200: WHERE bill_instance_number = p_bill_instance_num;
201:
202: CURSOR l_ra_tax_csr(p_id NUMBER) IS
203: SELECT nvl(sum(ctl.extended_amount),0 )
204: FROM RA_CUSTOMER_TRX_LINES_ALL CTL
205: WHERE CTL.LINK_TO_CUST_TRX_LINE_ID = p_id
206: AND CTL.line_type = 'TAX';
207:
208: