APPS.OKS_BILL_SCH dependencies on OKS_BILL_CONT_LINES

Line 10624: FROM oks_bill_cont_lines

10620: WHERE cle_id = p_line_id;
10621:
10622: CURSOR l_bcl_csr(p_line_id number, p_start_date date) IS
10623: SELECT date_billed_to
10624: FROM oks_bill_cont_lines
10625: WHERE cle_id = p_line_id
10626: AND TRUNC(date_billed_from) = TRUNC(p_start_date)
10627: AND bill_action = 'RI';
10628:

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';