40:
41: ) IS
42: l_api_name VARCHAR2(30);
43: l_api_version NUMBER;
44: l_user_key wf_items.user_key%TYPE;
45: l_wf_sequence wf_items.item_key%TYPE;
46: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%TYPE;
47:
48: CURSOR contract_csr IS
41: ) IS
42: l_api_name VARCHAR2(30);
43: l_api_version NUMBER;
44: l_user_key wf_items.user_key%TYPE;
45: l_wf_sequence wf_items.item_key%TYPE;
46: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%TYPE;
47:
48: CURSOR contract_csr IS
49: SELECT contract_number