APPS.OKS_USAGE_SETTLE_PUB dependencies on OKS_BILL_SUB_LINE_DTLS

Line 53: FROM oks_bill_sub_line_dtls ldtl

49: CURSOR l_actual_billed_csr(p_cle_id IN NUMBER) Is
50: SELECT NVL(sum(NVL(Result,0)),0) qty,
51: sum(line.amount) amt,
52: max(line.date_billed_to) max_bill_to
53: FROM oks_bill_sub_line_dtls ldtl
54: ,oks_bill_sub_lines line
55: WHERE line.cle_id = p_cle_id
56: AND ldtl.bsl_id = line.id;
57:

Line 68: oks_bill_sub_line_dtls bsd

64: bsl.amount,
65: bsd.result
66: FROM oks_bill_cont_lines bcl,
67: oks_bill_sub_lines bsl,
68: oks_bill_sub_line_dtls bsd
69: WHERE bcl.id = bsl.bcl_id
70: AND bcl.bill_action = 'RI'
71: AND bsl.cle_id = p_cle_id
72: AND bsd.bsl_id = bsl.id