APPS.OKS_SETUP_UTIL_PUB dependencies on OKC_PRICE_ADJUSTMENTS

Line 2692: from okc_price_adjustments

2688: and date_terminated is not null;
2689:
2690: cursor cur_pradj (p_chr_id NUMBEr) is
2691: select chr_id,cle_id
2692: from okc_price_adjustments
2693: where chr_id =p_chr_id
2694: and cle_id is not null;
2695:
2696: cursor is_line_copy(l_new_chr_id number, l_old_chr_id number) is

Line 2948: update okc_price_adjustments

2944: OR p_cle_id = OKC_API.G_MISS_NUM)) THEN
2945:
2946: For cur_pradj_rec in cur_pradj(p_chr_id)
2947: LOOP
2948: update okc_price_adjustments
2949: set chr_id = null
2950: where chr_id =cur_pradj_rec.chr_id
2951: and cle_id =cur_pradj_rec.cle_id;
2952: END LOOP;