APPS.OKS_SETUP_UTIL_PUB dependencies on OKC_PRICE_ADJUSTMENTS

Line 2683: from okc_price_adjustments

2679: and date_terminated is not null;
2680:
2681: cursor cur_pradj (p_chr_id NUMBEr) is
2682: select chr_id,cle_id
2683: from okc_price_adjustments
2684: where chr_id =p_chr_id
2685: and cle_id is not null;
2686:
2687: cursor is_line_copy(l_new_chr_id number, l_old_chr_id number) is

Line 2939: update okc_price_adjustments

2935: OR p_cle_id = OKC_API.G_MISS_NUM)) THEN
2936:
2937: For cur_pradj_rec in cur_pradj(p_chr_id)
2938: LOOP
2939: update okc_price_adjustments
2940: set chr_id = null
2941: where chr_id =cur_pradj_rec.chr_id
2942: and cle_id =cur_pradj_rec.cle_id;
2943: END LOOP;