APPS.OKC_REP_STATUS_UPDATE_PVT dependencies on OKC_REP_CONTRACT_VERS

Line 71: FROM okc_rep_contract_vers v

67: SELECT
68: contract_id, contract_version_num,
69: contract_number,
70: contract_name
71: FROM okc_rep_contract_vers v
72: WHERE termination_date IS NOT NULL
73: AND contract_status_code = G_REP_CON_STATUS_SIGNED
74: AND trunc(termination_date) <= trunc(SYSDATE);
75:

Line 250: UPDATE okc_rep_contract_vers

246:
247: END LOOP;
248:
249: FORALL j IN NVL(selected_vers_contract_ids.FIRST,0)..NVL(selected_vers_contract_ids.LAST,-1)
250: UPDATE okc_rep_contract_vers
251: SET contract_status_code = p_status,
252: last_update_date = sysdate,
253: last_updated_by = Fnd_Global.User_Id,
254: last_update_login = Fnd_Global.Login_Id