2742:
2743: CURSOR csr_ben_per (c_person_id IN NUMBER
2744: ,c_benefit_action_id IN NUMBER) IS
2745: SELECT *
2746: FROM ben_person_actions bpa
2747: WHERE bpa.benefit_action_id = c_benefit_action_id
2748: AND bpa.person_id = c_person_id;
2749:
2750: l_ben_per csr_ben_per%ROWTYPE;
2765: ,c_benefit_action_id => p_benefit_action_id);
2766: FETCH csr_ben_per INTO l_ben_per;
2767: CLOSE csr_ben_per;
2768:
2769: UPDATE ben_person_actions bpa
2770: SET bpa.action_status_cd = 'U'
2771: WHERE bpa.benefit_action_id = p_benefit_action_id
2772: AND bpa.person_id = p_person_id;
2773: IF p_flag_thread = 'Y' THEN
5321: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
5322: ,c_business_group_id => p_business_group_id);
5323: FETCH csr_ben INTO l_ben_params;
5324: CLOSE csr_ben;
5325: -- Flag the person in ben_person_actions and ben_batch_ranges
5326: -- as Unporcessed and errored.
5327: FOR err_rec IN csr_err(c_bg_id => p_business_group_id
5328: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id)
5329: LOOP