APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKC_STATUSES_V

Line 3929: FROM okc_k_headers_all_b a, okc_statuses_v b

3925: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS
3926: SELECT a.application_id, a.contract_number, a.contract_number_modifier,
3927: b.ste_code, b.meaning, a.scs_code, a.template_yn,
3928: a.date_terminated, a.date_renewed, a.end_date
3929: FROM okc_k_headers_all_b a, okc_statuses_v b
3930: WHERE a.id = cp_chr_id AND a.sts_code = b.code;
3931:
3932: --cursor to check if all sublines and subscr toplines have been renew consolidated
3933: CURSOR c_check_line_rencon(cp_chr_id IN NUMBER) IS