DBA Data[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: