APPS.OKS_BILL_SCH dependencies on OKS_BILL_SUB_LINES

Line 423: FROM oks_bill_sub_lines bsl

419: Cursor total_billed_csr (p_cle_id IN NUMBER) IS
420: SELECT nvl(sum(bsl.amount),0) amount,
421: max(bsl.date_billed_From) date_billed_From,
422: max(bsl.date_billed_to) date_billed_to
423: FROM oks_bill_sub_lines bsl
424: WHERE bsl.cle_id = p_cle_id;
425:
426:
427: Cursor check_sub_instance IS

Line 10874: FROM oks_bill_sub_lines bsl, oks_bill_cont_lines bcl

10870: AND bill_action = 'RI';
10871:
10872: CURSOR l_bsl_csr(p_line_id number, p_start_date date) IS
10873: SELECT bsl.date_billed_to
10874: FROM oks_bill_sub_lines bsl, oks_bill_cont_lines bcl
10875: WHERE bsl.cle_id = p_line_id
10876: AND TRUNC(bsl.date_billed_from) = TRUNC(p_start_date)
10877: AND bsl.bcl_id = bcl.id
10878: AND bcl.bill_action = 'RI';

Line 11848: ------update oks_bill_sub_lines with new cle_id

11844:
11845: END IF; ----chk for bill type E and P
11846:
11847:
11848: ------update oks_bill_sub_lines with new cle_id
11849:
11850: UPDATE oks_bill_sub_lines
11851: SET cle_id = p_new_cp_id
11852: WHERE cle_id = p_old_cp_id;

Line 11850: UPDATE oks_bill_sub_lines

11846:
11847:
11848: ------update oks_bill_sub_lines with new cle_id
11849:
11850: UPDATE oks_bill_sub_lines
11851: SET cle_id = p_new_cp_id
11852: WHERE cle_id = p_old_cp_id;
11853:
11854: