APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_BILL_CONT_LINES

Line 5484: FROM oks_bill_cont_lines

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');
5486:
5487: CURSOR get_top_billed_amount(l_line_id NUMBER) IS
5488: SELECT SUM(amount)

Line 5489: FROM oks_bill_cont_lines

5485: WHERE bill_action = 'RI');
5486:
5487: CURSOR get_top_billed_amount(l_line_id NUMBER) IS
5488: SELECT SUM(amount)
5489: FROM oks_bill_cont_lines
5490: WHERE cle_id = l_line_id AND
5491: bill_action = 'RI';
5492:
5493: CURSOR sll_end_date_csr(l_cle_id NUMBER) IS