APPS.OKC_REP_EXP_NTF_PVT dependencies on OKC_REP_CONTRACTS_ALL

Line 61: FROM okc_rep_contracts_all

57: contract_version_num,
58: DECODE(SIGN(MONTHS_BETWEEN(contract_expiration_date, trunc(sysdate))),
59: 1, 'N', 'Y') AS expired_flag,
60: notify_contact_role_id
61: FROM okc_rep_contracts_all
62: WHERE contract_expiration_date is not null
63: AND contract_status_code = 'SIGNED'
64: AND expire_ntf_flag = 'Y'
65: AND contract_expiration_date <= trunc(sysdate) + expire_ntf_period

Line 75: FROM okc_rep_contract_vers v ,okc_rep_contracts_all v2

71: v.contract_version_num,
72: DECODE(SIGN(MONTHS_BETWEEN(v.contract_expiration_date, trunc(sysdate))),
73: 1, 'N', 'Y') AS expired_flag,
74: v.notify_contact_role_id
75: FROM okc_rep_contract_vers v ,okc_rep_contracts_all v2
76: WHERE v.contract_status_code = 'SIGNED'
77: AND v2.contract_id = v.contract_id
78: AND v2.contract_status_code NOT IN('SIGNED','TERMINATED','APPROVED')
79: AND v.expire_ntf_flag = 'Y'

Line 89: FROM okc_rep_contracts_all c1

85: FROM okc_rep_contract_vers v1
86: WHERE v1.contract_id = v.contract_id)
87: AND NOT EXISTS(
88: SELECT 1
89: FROM okc_rep_contracts_all c1
90: WHERE c1.contract_id = v.contract_id
91: AND c1.contract_status_code = 'SIGNED'
92: AND c1.expire_ntf_flag = 'Y'
93: AND c1.contract_expiration_date <= TRUNC(SYSDATE) + c1.expire_ntf_period