APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_BILL_SUB_LINES
Line 5481: FROM oks_bill_sub_lines
5477:
5478:
5479: CURSOR get_billed_amount(l_sub_line_id NUMBER) IS
5480: SELECT SUM(amount) 5481: FROM oks_bill_sub_lines 5482: WHERE cle_id = l_sub_line_id
5483: AND bcl_id IN (SELECT id
5484: FROM oks_bill_cont_lines
5485: WHERE bill_action = 'RI');