APPS.OKC_CONTRACT_APPROVAL_PVT dependencies on OKC_K_LINES_B

Line 2000: from okc_k_lines_b L

1996: ,decode(sign(months_between(sysdate-1, NVL(L.end_date,sysdate))),-1,
1997: decode(sign(months_between(p_date_signed-1,sysdate)),-1,
1998: decode(sign(months_between(L.start_date-1,sysdate)),-1,
1999: l_active_status,l_signed_status),l_signed_status),l_expired_status) STS_CODE
2000: from okc_k_lines_b L
2001: , okc_statuses_b S
2002: where L.dnz_chr_id = p_contract_id
2003: and S.code = L.sts_code
2004: and S.ste_code='ENTERED'

Line 2162: FROM okc_k_lines_b l, okc_statuses_b s

2158: 'updating line status');
2159: END IF;
2160:
2161: UPDATE (SELECT l.sts_code, l.start_date, l.end_date
2162: FROM okc_k_lines_b l, okc_statuses_b s
2163: WHERE l.dnz_chr_id = p_contract_id
2164: AND s.code = l.sts_code
2165: AND s.ste_code = 'ENTERED') oks
2166: SET