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 10631: FROM oks_bill_sub_lines bsl, oks_bill_cont_lines bcl

10627: AND bill_action = 'RI';
10628:
10629: CURSOR l_bsl_csr(p_line_id number, p_start_date date) IS
10630: SELECT bsl.date_billed_to
10631: FROM oks_bill_sub_lines bsl, oks_bill_cont_lines bcl
10632: WHERE bsl.cle_id = p_line_id
10633: AND TRUNC(bsl.date_billed_from) = TRUNC(p_start_date)
10634: AND bsl.bcl_id = bcl.id
10635: AND bcl.bill_action = 'RI';

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

11601:
11602: END IF; ----chk for bill type E and P
11603:
11604:
11605: ------update oks_bill_sub_lines with new cle_id
11606:
11607: UPDATE oks_bill_sub_lines
11608: SET cle_id = p_new_cp_id
11609: WHERE cle_id = p_old_cp_id;

Line 11607: UPDATE oks_bill_sub_lines

11603:
11604:
11605: ------update oks_bill_sub_lines with new cle_id
11606:
11607: UPDATE oks_bill_sub_lines
11608: SET cle_id = p_new_cp_id
11609: WHERE cle_id = p_old_cp_id;
11610:
11611: