DBA Data[Home] [Help]

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 1114: FROM oks_level_elements ole

1110: p_return_status IN OUT NOCOPY VARCHAR2)
1111: IS
1112: Cursor l_get_top_line_lvl_id(p_cle_id IN NUMBER,p_start_date IN DATE) is
1113: SELECT to_char(ole.date_start,'YYYY/MM/DD')
1114: FROM oks_level_elements ole
1115: WHERE ole.cle_id = p_cle_id
1116: AND trunc(p_start_date) >= trunc(ole.date_start)
1117: ORDER BY ole.date_start desc;
1118: --AND p_start_date between ole.date_start and ole.date_end;

Line 1225: oks_level_elements lvl

1221: p_date_billed_from IN DATE) is
1222:
1223: SELECT str.invoice_offset_days --str.action_offset_days
1224: FROM oks_stream_levels_b str,
1225: oks_level_elements lvl
1226: WHERE lvl.cle_id = p_cle_id
1227: AND trunc(p_date_billed_from) between trunc(lvl.date_start)
1228: and trunc(lvl.date_end)
1229: AND lvl.rul_id = str.id;