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 2169: FROM okc_k_lines_b l, okc_statuses_b s

2165: team has suggested to modify the product code in order to handle the error through bug12402762*/
2166:
2167: /*commented the below UPDATE statement and modified as per ATG suggestion
2168: UPDATE (SELECT l.sts_code, l.start_date, l.end_date, l.last_update_date, l.last_update_login, l.Last_updated_by
2169: FROM okc_k_lines_b l, okc_statuses_b s
2170: WHERE l.dnz_chr_id = p_contract_id
2171: AND s.code = l.sts_code
2172: AND s.ste_code = 'ENTERED') oks
2173: SET

Line 2184: FROM okc_k_lines_b l

2180: oks.last_update_login = FND_GLOBAL.LOGIN_ID,
2181: oks.last_updated_by = FND_GLOBAL.USER_ID;
2182: */
2183: UPDATE (SELECT l.sts_code, l.start_date, l.end_date, l.last_update_date, l.last_update_login, l.Last_updated_by
2184: FROM okc_k_lines_b l
2185: WHERE l.dnz_chr_id = p_contract_id) oks
2186: SET
2187: oks.sts_code =
2188: decode( sign(months_between(l_sysdate - 1, NVL(oks.end_date, l_sysdate))),