APPS.PQP_US_PENSION_EXTRACTS dependencies on BEN_PERSON_ACTIONS

Line 2746: FROM ben_person_actions bpa

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;

Line 2769: UPDATE ben_person_actions bpa

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

Line 5325: -- Flag the person in ben_person_actions and ben_batch_ranges

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