[Home] [Help]
330: and fnd.request_id = v_request_id;
331: --
332: cursor c_master is
333: select 'Y'
334: from ben_benefit_actions bft
335: where bft.benefit_action_id = g_parm.benefit_action_id
336: and bft.request_id = fnd_global.conc_request_id;
337: --
338: cursor c_person_actions(p_status_cd varchar2) is
3115: -- Cursor Declaration
3116: --
3117: cursor c_parm is
3118: select *
3119: from ben_benefit_actions ben
3120: where ben.benefit_action_id = p_benefit_action_id;
3121: --
3122: l_parm c_parm%rowtype;
3123: --
3244: -- PB : 5422 :
3245: -- ,ben.popl_enrt_typ_cycl_id
3246: ,ben.lf_evt_ocrd_dt
3247: ,ben.audit_log_flag
3248: from ben_benefit_actions ben
3249: where ben.benefit_action_id = p_benefit_action_id;
3250: --
3251: l_effective_date date;
3252: l_proc varchar2(80) := g_package || '.do_multithread';
4768: if p_benefit_action_id is null then
4769: --
4770: -- A new request was submitted. Create a new benefit action.
4771: --
4772: ben_benefit_actions_api.create_benefit_actions
4773: (p_validate => FALSE
4774: ,p_benefit_action_id => g_parm.benefit_action_id
4775: ,p_process_date => l_effective_date
4776: ,p_mode_cd => p_mode
4941: --
4942: cursor c_tot_person_cm is
4943: select count(distinct bmi.person_id)
4944: from ben_batch_commu_info bmi,
4945: ben_benefit_actions bft
4946: where bft.request_id = p_concurrent_request_id
4947: and bft.benefit_action_id = bmi.benefit_action_id;
4948: --
4949: cursor c_tot_person_1_cm is
4948: --
4949: cursor c_tot_person_1_cm is
4950: select count(*)
4951: from ben_batch_commu_info bmi1,
4952: ben_benefit_actions bft
4953: where bft.request_id = p_concurrent_request_id
4954: and bft.benefit_action_id = bmi1.benefit_action_id
4955: and not exists ( select 1
4956: from ben_batch_commu_info bmi2
5065: cla.name cmbn_age_los_fctr,
5066: bft.date_from date_from,
5067: conc.user_concurrent_program_name conc_prog_name,
5068: fnd1.meaning
5069: from ben_benefit_actions bft,
5070: hr_lookups hr1,
5071: hr_lookups hr2,
5072: hr_lookups hr3,
5073: hr_lookups hr4,