APPS.PQP_PENSION_EXTRACTS dependencies on BEN_BATCH_RANGES

Line 1940: FROM ben_batch_ranges

1936:
1937: CURSOR csr_rng (c_benefit_action_id IN NUMBER
1938: ,c_person_action_id IN NUMBER) IS
1939: SELECT 'x'
1940: FROM ben_batch_ranges
1941: WHERE benefit_action_id = c_benefit_action_id
1942: AND c_person_action_id BETWEEN starting_person_action_id
1943: AND ending_person_action_id;
1944: l_conc_reqest_id NUMBER(20);

Line 1963: UPDATE ben_batch_ranges bbr

1959: OPEN csr_rng (c_benefit_action_id => p_benefit_action_id
1960: ,c_person_action_id => l_ben_per.person_action_id);
1961: FETCH csr_rng INTO l_exists;
1962: CLOSE csr_rng;
1963: UPDATE ben_batch_ranges bbr
1964: SET bbr.range_status_cd = 'E'
1965: WHERE bbr.benefit_action_id = p_benefit_action_id
1966: AND l_ben_per.person_action_id
1967: BETWEEN bbr.starting_person_action_id

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

4503: ,c_business_group_id => p_business_group_id);
4504: FETCH csr_ben INTO l_ben_params;
4505: CLOSE csr_ben;
4506:
4507: -- Flag the person in ben_person_actions and ben_batch_ranges
4508: -- as Unporcessed and errored.
4509: FOR err_rec IN csr_err(c_bg_id => p_business_group_id
4510: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id)
4511: LOOP