APPS.OKC_CONTRACT_PUB dependencies on OKC_K_LINES_V

Line 5711: from okc_k_headers_v H, okc_k_lines_v L, okc_statuses_v S

5707: decode(sign(months_between(sysdate-1,NVL(L.end_date,sysdate))),-1,
5708: decode(sign(months_between(L.start_date-1,sysdate)),-1,p_sts_code,l_signed)
5709: ,l_expired)
5710: ,p_sts_code) code
5711: from okc_k_headers_v H, okc_k_lines_v L, okc_statuses_v S
5712: where H.id= p_id
5713: and L.dnz_chr_id = p_id
5714: and S.code = L.sts_code
5715: and S.ste_code in ('ENTERED','CANCELLED','ACTIVE','SIGNED','HOLD');