eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_US_NFC_EXTRACTS dependencies on BEN_PERSON_ACTIONS

Line 2437: from ben_person_actions bpa

2433:
2434: cursor csr_ben_per (c_person_id in number
2435: ,c_benefit_action_id in number) is
2436: select *
2437: from ben_person_actions bpa
2438: where bpa.benefit_action_id = c_benefit_action_id
2439: and bpa.person_id = c_person_id;
2440:
2441: l_ben_per csr_ben_per%rowtype;

Line 2461: update ben_person_actions bpa

2457: ,c_benefit_action_id => p_benefit_action_id);
2458: fetch csr_ben_per into l_ben_per;
2459: close csr_ben_per;
2460:
2461: update ben_person_actions bpa
2462: set bpa.action_status_cd = 'U'
2463: where bpa.benefit_action_id = p_benefit_action_id
2464: and bpa.person_id = p_person_id;
2465:

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