APPS.OKS_BILL_REC_PUB dependencies on OKS_STREAM_LEVELS_B

Line 393: FROM oks_stream_levels_b str,

389: in case of summary billing bsl_id is null in above table*/
390:
391: Cursor rules_csr(l_termination_date IN DATE,p_cov_line_id IN NUMBER) IS
392: SELECT str.uom_code l_freq
393: FROM oks_stream_levels_b str,
394: oks_level_elements lvl
395: WHERE lvl.cle_id = p_cov_line_id
396: AND lvl.rul_id = str.id
397: AND l_termination_date between lvl.date_start and lvl.date_end;

Line 2010: FROM oks_stream_levels_b str,

2006: AND trunc(bcl.date_billed_from) <= trunc(p_terminate_date);
2007:
2008: Cursor rules_csr(p_line_id in number,p_termination_date in Date) Is
2009: SELECT str.uom_code l_freq
2010: FROM oks_stream_levels_b str,
2011: oks_level_elements lvl
2012: WHERE lvl.cle_id = p_line_id
2013: AND p_termination_date BETWEEN lvl.date_start AND lvl.date_end
2014: AND lvl.rul_id = str.id;

Line 5775: FROM oks_stream_levels_b

5771: --Will be used for partial periods
5772: -------------------------------------------
5773: CURSOR l_Billuom_csr(p_date IN DATE) IS
5774: SELECT UOM_CODE
5775: FROM oks_stream_levels_b
5776: WHERE cle_id = p_cle_id
5777: AND trunc(p_date) >= START_DATE
5778: AND trunc(p_date) <= END_DATE;
5779: ---------------------------------------------