APPS.OKS_BILL_SCH dependencies on OKS_BILL_CONT_LINES

Line 10867: FROM oks_bill_cont_lines

10863: WHERE cle_id = p_line_id;
10864:
10865: CURSOR l_bcl_csr(p_line_id number, p_start_date date) IS
10866: SELECT date_billed_to
10867: FROM oks_bill_cont_lines
10868: WHERE cle_id = p_line_id
10869: AND TRUNC(date_billed_from) = TRUNC(p_start_date)
10870: AND bill_action = 'RI';
10871:

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