APPS.OKC_RENEW_PUB dependencies on OKC_SUBCLASSES_B

Line 214: l_cls_code OKC_SUBCLASSES_B.CLS_CODE%TYPE:=OKC_API.G_MISS_CHAR;

210: p_do_commit IN VARCHAR2 ,
211: p_renewal_called_from_ui IN VARCHAR2 /* added for bugfix 2093117 */
212: ) is
213:
214: l_cls_code OKC_SUBCLASSES_B.CLS_CODE%TYPE:=OKC_API.G_MISS_CHAR;
215: l_renew_in_parameters_rec Renew_in_parameters_rec; -- this has to be empty
216: l_proc varchar2(4000);
217:
218: -- bug 4777431 , skekkar

Line 221: from okc_k_headers_all_b,okc_subclasses_b -- bug 4777431

217:
218: -- bug 4777431 , skekkar
219: CURSOR cur_scs(p_chr_id number) is
220: select cls_code
221: from okc_k_headers_all_b,okc_subclasses_b -- bug 4777431
222: WHERE id=p_chr_id and code=scs_code;
223: l_renew_not_found exception;
224: PRAGMA EXCEPTION_INIT(l_Renew_Not_found, -6550);
225: begin