APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKS_STREAM_LEVELS_B

Line 2226: FROM oks_stream_levels_b

2222: CURSOR c_hdr_strlvl(cp_chr_id NUMBER) IS
2223: SELECT id, chr_id, cle_id, dnz_chr_id, sequence_no, uom_code, start_date, level_periods,
2224: uom_per_period, advance_periods, level_amount, invoice_offset_days, interface_offset_days,
2225: comments, due_arr_yn, amount, lines_detailed_yn
2226: FROM oks_stream_levels_b
2227: WHERE chr_id = cp_chr_id
2228: ORDER BY sequence_no; --skuchima bug 11805576
2229:
2230: TYPE hdr_strlvl_tbl IS TABLE OF c_hdr_strlvl%ROWTYPE INDEX BY BINARY_INTEGER;

Line 2411: FROM oks_stream_levels_b

2407: CURSOR c_line_strlvl(cp_cle_id NUMBER) IS
2408: SELECT id, chr_id, cle_id, dnz_chr_id, sequence_no, uom_code, start_date, end_date,
2409: level_periods, uom_per_period, advance_periods, level_amount, invoice_offset_days,
2410: interface_offset_days, comments, due_arr_yn, amount, lines_detailed_yn
2411: FROM oks_stream_levels_b
2412: WHERE cle_id = cp_cle_id
2413: ORDER BY sequence_no; ---skuchima bug 11805576
2414:
2415:

Line 3035: DELETE FROM oks_stream_levels_b

3031:
3032: DELETE FROM oks_level_elements
3033: WHERE dnz_chr_id = p_chr_id;
3034:
3035: DELETE FROM oks_stream_levels_b
3036: WHERE dnz_chr_id = p_chr_id;
3037:
3038: --doing this becuase this is what OKS_BILL_SCH.del_rul_elements does
3039: --and we are replacing that call