APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKC_STATUSES_V

Line 3964: FROM okc_k_headers_all_b a, okc_statuses_v b

3960: CURSOR c_k_hdr(cp_chr_id IN NUMBER) IS
3961: SELECT a.application_id, a.contract_number, a.contract_number_modifier,
3962: b.ste_code, b.meaning, a.scs_code, a.template_yn,
3963: a.date_terminated, a.date_renewed, a.end_date
3964: FROM okc_k_headers_all_b a, okc_statuses_v b
3965: WHERE a.id = cp_chr_id AND a.sts_code = b.code;
3966:
3967: --cursor to check if all sublines and subscr toplines have been renew consolidated
3968: CURSOR c_check_line_rencon(cp_chr_id IN NUMBER) IS