[Home] [Help]
1824: WHERE contract_id = p_contract_id;
1825:
1826: CURSOR arch_contract_csr (l_contract_version NUMBER,p_contract_id number) IS
1827: SELECT contract_effective_date, contract_expiration_date
1828: FROM OKC_REP_CONTRACT_VERS
1829: WHERE contract_id = p_contract_id
1830: AND contract_version_num = l_contract_version;
1831:
1832: contract_rec contract_csr%ROWTYPE;