APPS.OKE_CHANGE_STATUS_PUB dependencies on OKC_K_HEADERS_B

Line 147: Select sts_code, start_date, end_date from okc_k_headers_b where id = p_id;

143: cursor get_ste_code(p_code in varchar2) is
144: Select ste_code from okc_statuses_b where code = p_code;
145:
146: cursor get_k_hdr_cur (p_id in number) is
147: Select sts_code, start_date, end_date from okc_k_headers_b where id = p_id;
148:
149: CURSOR check_valid_status(p_new_sts_code VARCHAR2,
150: p_new_ste_code VARCHAR2,
151: p_old_sts_code VARCHAR2,

Line 300: FROM okc_k_headers_b

296: CURSOR c_obj_ver(p_id NUMBER) IS
297: SELECT object_version_number, decode(
298: NVL(sign(months_between(START_DATE,sysdate+1)),1),-1,decode(
299: NVL(sign(months_between(END_DATE,sysdate-1)),1),1,'ACTIVE','EXPIRED'),'SIGNED' )
300: FROM okc_k_headers_b
301: WHERE id = p_id;
302:
303: BEGIN
304: x_chrv_tbl(i).VALIDATE_YN := 'N';