APPS.OKS_ARFEEDER_PUB dependencies on OKS_LEVEL_ELEMENTS

Line 169: from oks_level_elements lvl,

165: p_attribute_category IN VARCHAR2)
166: IS
167: Cursor cur_line_sll_count (p_cle_id in NUMBER,p_date in Date) IS
168: SELECT count(lvl.id) tot_no_of_lvl,sub.nos no_of_lvl
169: from oks_level_elements lvl,
170: (select count(*) nos
171: from oks_level_elements lev
172: where lev.cle_id = p_cle_id
173: and trunc(lev.date_start) <= trunc(p_date)

Line 171: from oks_level_elements lev

167: Cursor cur_line_sll_count (p_cle_id in NUMBER,p_date in Date) IS
168: SELECT count(lvl.id) tot_no_of_lvl,sub.nos no_of_lvl
169: from oks_level_elements lvl,
170: (select count(*) nos
171: from oks_level_elements lev
172: where lev.cle_id = p_cle_id
173: and trunc(lev.date_start) <= trunc(p_date)
174: ) sub
175: WHERE lvl.cle_id = p_cle_id

Line 1128: FROM oks_level_elements ole

1124: p_return_status IN OUT NOCOPY VARCHAR2)
1125: IS
1126: Cursor l_get_top_line_lvl_id(p_cle_id IN NUMBER,p_start_date IN DATE) is
1127: SELECT to_char(ole.date_start,'YYYY/MM/DD')
1128: FROM oks_level_elements ole
1129: WHERE ole.cle_id = p_cle_id
1130: AND trunc(p_start_date) >= trunc(ole.date_start)
1131: ORDER BY ole.date_start desc;
1132: --AND p_start_date between ole.date_start and ole.date_end;

Line 1239: oks_level_elements lvl

1235: p_date_billed_from IN DATE) is
1236:
1237: SELECT str.invoice_offset_days --str.action_offset_days
1238: FROM oks_stream_levels_b str,
1239: oks_level_elements lvl
1240: WHERE lvl.cle_id = p_cle_id
1241: AND trunc(p_date_billed_from) between trunc(lvl.date_start)
1242: and trunc(lvl.date_end)
1243: AND lvl.rul_id = str.id;