DBA Data[Home] [Help]

APPS.OKS_ARFETCH_PUB dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 200: FROM RA_CUSTOMER_TRX_LINES_ALL CTL

196: WHERE bill_instance_number = p_bill_instance_num;
197:
198: CURSOR l_ra_tax_csr(p_id NUMBER) IS
199: SELECT nvl(sum(ctl.extended_amount),0 )
200: FROM RA_CUSTOMER_TRX_LINES_ALL CTL
201: WHERE CTL.LINK_TO_CUST_TRX_LINE_ID = p_id
202: AND CTL.line_type = 'TAX';
203:
204: