APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKS_STREAM_LEVELS_B

Line 2218: FROM oks_stream_levels_b

2214: CURSOR c_hdr_strlvl(cp_chr_id NUMBER) IS
2215: SELECT id, chr_id, cle_id, dnz_chr_id, sequence_no, uom_code, start_date, level_periods,
2216: uom_per_period, advance_periods, level_amount, invoice_offset_days, interface_offset_days,
2217: comments, due_arr_yn, amount, lines_detailed_yn
2218: FROM oks_stream_levels_b
2219: WHERE chr_id = cp_chr_id;
2220:
2221: TYPE hdr_strlvl_tbl IS TABLE OF c_hdr_strlvl%ROWTYPE INDEX BY BINARY_INTEGER;
2222:

Line 2402: FROM oks_stream_levels_b

2398: CURSOR c_line_strlvl(cp_cle_id NUMBER) IS
2399: SELECT id, chr_id, cle_id, dnz_chr_id, sequence_no, uom_code, start_date, end_date,
2400: level_periods, uom_per_period, advance_periods, level_amount, invoice_offset_days,
2401: interface_offset_days, comments, due_arr_yn, amount, lines_detailed_yn
2402: FROM oks_stream_levels_b
2403: WHERE cle_id = cp_cle_id;
2404:
2405: TYPE line_strlvl_tbl IS TABLE OF c_line_strlvl%ROWTYPE INDEX BY BINARY_INTEGER;
2406:

Line 3024: DELETE FROM oks_stream_levels_b

3020:
3021: DELETE FROM oks_level_elements
3022: WHERE dnz_chr_id = p_chr_id;
3023:
3024: DELETE FROM oks_stream_levels_b
3025: WHERE dnz_chr_id = p_chr_id;
3026:
3027: --doing this becuase this is what OKS_BILL_SCH.del_rul_elements does
3028: --and we are replacing that call