3345:
3346: CURSOR l_bill_csr
3347: IS
3348: SELECT date_billed_from, date_billed_to, creation_date
3349: FROM oks_bill_cont_lines_v
3350: WHERE cle_id = p_cle_id;
3351:
3352: l_bill_rec l_bill_csr%ROWTYPE;
3353: x_bill_from_date DATE;
5701: IS
5702: CURSOR l_hdr_bill_cont_lines_csr
5703: IS
5704: SELECT TRUNC (MAX (date_billed_to))
5705: FROM oks_bill_cont_lines
5706: WHERE cle_id IN (
5707: SELECT ID
5708: FROM okc_k_lines_b
5709: WHERE dnz_chr_id = p_chr_id
5711:
5712: CURSOR l_bill_cont_line_csr
5713: IS
5714: SELECT TRUNC (MAX (date_billed_to))
5715: FROM oks_bill_cont_lines
5716: WHERE cle_id = p_cle_id;
5717:
5718: CURSOR l_bill_sub_line_csr
5719: IS