APPS.OKS_BILL_REC_PUB dependencies on OKS_STREAM_LEVELS_B

Line 390: FROM oks_stream_levels_b str,

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

Line 1996: FROM oks_stream_levels_b str,

1992: AND trunc(bcl.date_billed_from) <= trunc(p_terminate_date);
1993:
1994: Cursor rules_csr(p_line_id in number,p_termination_date in Date) Is
1995: SELECT str.uom_code l_freq
1996: FROM oks_stream_levels_b str,
1997: oks_level_elements lvl
1998: WHERE lvl.cle_id = p_line_id
1999: AND p_termination_date BETWEEN lvl.date_start AND lvl.date_end
2000: AND lvl.rul_id = str.id;

Line 5749: FROM oks_stream_levels_b

5745: --Will be used for partial periods
5746: -------------------------------------------
5747: CURSOR l_Billuom_csr(p_date IN DATE) IS
5748: SELECT UOM_CODE
5749: FROM oks_stream_levels_b
5750: WHERE cle_id = p_cle_id
5751: AND trunc(p_date) >= START_DATE
5752: AND trunc(p_date) <= END_DATE;
5753: ---------------------------------------------