APPS.PQP_PENSION_EXTRACTS dependencies on BEN_PERSON_ACTIONS

Line 1931: FROM ben_person_actions bpa

1927:
1928: CURSOR csr_ben_per (c_person_id IN NUMBER
1929: ,c_benefit_action_id IN NUMBER) IS
1930: SELECT *
1931: FROM ben_person_actions bpa
1932: WHERE bpa.benefit_action_id = c_benefit_action_id
1933: AND bpa.person_id = c_person_id;
1934:
1935: l_ben_per csr_ben_per%ROWTYPE;

Line 1954: UPDATE ben_person_actions bpa

1950: ,c_benefit_action_id => p_benefit_action_id);
1951: FETCH csr_ben_per INTO l_ben_per;
1952: CLOSE csr_ben_per;
1953:
1954: UPDATE ben_person_actions bpa
1955: SET bpa.action_status_cd = 'U'
1956: WHERE bpa.benefit_action_id = p_benefit_action_id
1957: AND bpa.person_id = p_person_id;
1958: IF p_flag_thread = 'Y' THEN

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