APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_BILL_CONT_LINES

Line 5631: FROM oks_bill_cont_lines

5627: SELECT SUM(amount)
5628: FROM oks_bill_sub_lines
5629: WHERE cle_id = l_sub_line_id
5630: AND bcl_id IN (SELECT id
5631: FROM oks_bill_cont_lines
5632: WHERE bill_action = 'RI');
5633:
5634: CURSOR get_top_billed_amount(l_line_id NUMBER) IS
5635: SELECT SUM(amount)

Line 5636: FROM oks_bill_cont_lines

5632: WHERE bill_action = 'RI');
5633:
5634: CURSOR get_top_billed_amount(l_line_id NUMBER) IS
5635: SELECT SUM(amount)
5636: FROM oks_bill_cont_lines
5637: WHERE cle_id = l_line_id AND
5638: bill_action = 'RI';
5639:
5640: CURSOR sll_end_date_csr(l_cle_id NUMBER) IS