APPS.OKC_REP_EXP_NTF_PVT dependencies on OKC_REP_CONTRACT_VERS

Line 75: FROM okc_rep_contract_vers v

71: v.contract_version_num,
72: DECODE(SIGN(MONTHS_BETWEEN(contract_expiration_date, trunc(sysdate))),
73: 1, 'N', 'Y') AS expired_flag,
74: notify_contact_role_id
75: FROM okc_rep_contract_vers v
76: WHERE v.contract_status_code = 'SIGNED'
77: AND v.expire_ntf_flag = 'Y'
78: AND v.contract_expiration_date <= trunc(sysdate) + v.expire_ntf_period
79: AND v.wf_exp_ntf_item_key IS NULL

Line 83: FROM okc_rep_contract_vers v1

79: AND v.wf_exp_ntf_item_key IS NULL
80: AND v.contract_version_num = (
81: SELECT DISTINCT MAX(v1.contract_version_num)
82: OVER (PARTITION BY v1.contract_id)
83: FROM okc_rep_contract_vers v1
84: WHERE v1.contract_id = v.contract_id)
85: AND NOT EXISTS(
86: SELECT 1
87: FROM okc_rep_contracts_all c1