APPS.OKS_AVG_SET_PUB dependencies on OKS_BILL_CONT_LINES

Line 22: SELECT trunc(date_billed_from) date_billed_from FROM oks_bill_cont_lines

18: WHERE id = p_hdr_id;
19:
20: Cursor get_avg_date (p_cle_id IN NUMBER)
21: IS
22: SELECT trunc(date_billed_from) date_billed_from FROM oks_bill_cont_lines
23: WHERE cle_id = p_cle_id
24: order by date_billed_to desc;
25:
26: Cursor sub_line_csr (p_cle_id IN NUMBER,

Line 39: (select bcl.id from oks_bill_cont_lines bcl

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
41: AND trunc(bcl.date_billed_from) >= p_date
42: and bcl.cle_id = p_cle_id )
43: group by bsl.cle_id;

Line 52: FROM oks_bill_cont_lines

48: IS
49: SELECT id bcl_id
50: ,Date_Billed_from Date_Billed_from
51: ,Date_Billed_to Date_Billed_to
52: FROM oks_bill_cont_lines
53: Where cle_id = p_cle_id
54: AND trunc(date_billed_from ) >= trunc(p_date_billed_from)
55: AND trunc(date_billed_to ) <= trunc(p_date_billed_to)
56: AND averaged_yn is NULL;

Line 240: UPDATE oks_bill_cont_lines

236: END LOOP;
237:
238: if l_total_credit > 0 then
239:
240: UPDATE oks_bill_cont_lines
241: Set averaged_YN = 'Y'
242: WHERE cle_id = p_cle_id;
243:
244: OKS_ARFEEDER_PUB.Get_REC_FEEDER