APPS.OKS_AVG_SET_PUB dependencies on OKS_BILL_SUB_LINE_DTLS

Line 35: oks_bill_sub_line_dtls bsd,

31: max(bsl.date_billed_to) date_billed_to,
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

Line 65: oks_bill_sub_line_dtls bsd

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;
69: