APPS.PQP_US_PENSION_EXTRACTS dependencies on BEN_BATCH_RANGES

Line 2755: FROM ben_batch_ranges

2751:
2752: CURSOR csr_rng (c_benefit_action_id IN NUMBER
2753: ,c_person_action_id IN NUMBER) IS
2754: SELECT 'x'
2755: FROM ben_batch_ranges
2756: WHERE benefit_action_id = c_benefit_action_id
2757: AND c_person_action_id BETWEEN starting_person_action_id
2758: AND ending_person_action_id;
2759: l_conc_reqest_id NUMBER(20);

Line 2778: UPDATE ben_batch_ranges bbr

2774: OPEN csr_rng (c_benefit_action_id => p_benefit_action_id
2775: ,c_person_action_id => l_ben_per.person_action_id);
2776: FETCH csr_rng INTO l_exists;
2777: CLOSE csr_rng;
2778: UPDATE ben_batch_ranges bbr
2779: SET bbr.range_status_cd = 'E'
2780: WHERE bbr.benefit_action_id = p_benefit_action_id
2781: AND l_ben_per.person_action_id
2782: BETWEEN bbr.starting_person_action_id

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