APPS.OKS_AVG_SET_PUB dependencies on OKS_BILL_SUB_LINES

Line 36: oks_bill_sub_lines bsl

32: sum(bsl.amount) amt_billed,
33: bsl.cle_id
34: FROM
35: oks_bill_sub_line_dtls bsd,
36: oks_bill_sub_lines bsl
37: WHERE bsd.bsl_id = bsl.id
38: AND bsl.bcl_id in
39: (select bcl.id from oks_bill_cont_lines bcl
40: where bcl.averaged_yn is null

Line 64: FROM oks_bill_sub_lines bsl,

60: SELECT bsd.unit_of_measure uom_code,
61: bsd.amcv_yn amcv_yn,
62: bsl.date_billed_from date_from,
63: bsl.date_billed_to date_to
64: FROM oks_bill_sub_lines bsl,
65: oks_bill_sub_line_dtls bsd
66: WHERE bsl.cle_id = p_cle_id
67: AND bsl.id = bsd.bsl_id
68: order by bsl.date_billed_to desc;