APPS.OKS_USAGE_SETTLE_PUB dependencies on OKS_BILL_SUB_LINES

Line 44: FROM oks_bill_sub_lines

40: CURSOR bsl_billed(p_cle_id IN NUMBER,p_date_billed_From IN DATE,
41: p_date_billed_to IN DATE)
42: IS
43: SELECT id
44: FROM oks_bill_sub_lines
45: WHERE cle_id = p_cle_id
46: AND trunc(date_billed_From)= trunc(p_date_billed_From)
47: AND trunc(date_billed_to) = trunc(p_date_billed_to) ;
48:

Line 54: ,oks_bill_sub_lines line

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:
58:

Line 67: oks_bill_sub_lines bsl,

63: bsl.date_billed_to,
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

Line 78: FROM oks_bill_sub_lines

74:
75: CURSOR count_bsl_csr(p_cle_id IN NUMBER)
76: IS
77: SELECT date_billed_from,date_billed_to
78: FROM oks_bill_sub_lines
79: WHERE cle_id = p_cle_id;
80:
81: CURSOR l_uom_csr IS
82: SELECT uom_code