35: l_activity_rec jtf_ih_pub.activity_rec_type;
36: lx_interaction_id NUMBER;
37: lx_activity_id NUMBER;
38:
39: l_crqv_rec okl_crq_pvt.crqv_rec_type;
40: lx_crqv_rec okl_crq_pvt.crqv_rec_type;
41:
42: CURSOR c_check_submitted IS
43: SELECT credit_req_number,
36: lx_interaction_id NUMBER;
37: lx_activity_id NUMBER;
38:
39: l_crqv_rec okl_crq_pvt.crqv_rec_type;
40: lx_crqv_rec okl_crq_pvt.crqv_rec_type;
41:
42: CURSOR c_check_submitted IS
43: SELECT credit_req_number,
44: status