APPS.GHR_US_NFC_EXTRACTS dependencies on BEN_BATCH_RANGES

Line 2446: from ben_batch_ranges

2442:
2443: cursor csr_rng (c_benefit_action_id in number
2444: ,c_person_action_id in number) is
2445: select 'x'
2446: from ben_batch_ranges
2447: where benefit_action_id = c_benefit_action_id
2448: and c_person_action_id between starting_person_action_id
2449: and ending_person_action_id;
2450: l_conc_reqest_id number(20);

Line 2473: update ben_batch_ranges bbr

2469: ,c_person_action_id => l_ben_per.person_action_id);
2470: fetch csr_rng into l_exists;
2471: close csr_rng;
2472:
2473: update ben_batch_ranges bbr
2474: set bbr.range_status_cd = 'E'
2475: where bbr.benefit_action_id = p_benefit_action_id
2476: and l_ben_per.person_action_id
2477: between bbr.starting_person_action_id

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

2534: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
2535: ,c_business_group_id => p_business_group_id);
2536: fetch csr_ben into l_ben_params;
2537: close csr_ben;
2538: -- Flag the person in ben_person_actions and ben_batch_ranges
2539: -- as Unporcessed and errored.
2540: for err_rec in csr_err(c_bg_id => p_business_group_id
2541: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id)
2542: loop