134: || l_api_name;
135: -- Selects the nextval from sequence, used later for defining event key
136: CURSOR okl_key_csr IS
137: SELECT okl_wf_item_s.nextval
138: FROM dual;
139:
140: cursor c_get_ref_details (p_cure_report_id IN NUMBER)
141: is select crt.report_number
142: ,pov.vendor_name