[Home] [Help]
326: and fnd.request_id = v_request_id;
327: --
328: cursor c_master is
329: select 'Y'
330: from ben_benefit_actions bft
331: where bft.benefit_action_id = g_parm.benefit_action_id
332: and bft.request_id = fnd_global.conc_request_id;
333: --
334: cursor c_person_actions(p_status_cd varchar2) is
3057: -- Cursor Declaration
3058: --
3059: cursor c_parm is
3060: select *
3061: from ben_benefit_actions ben
3062: where ben.benefit_action_id = p_benefit_action_id;
3063: --
3064: l_parm c_parm%rowtype;
3065: --
3186: -- PB : 5422 :
3187: -- ,ben.popl_enrt_typ_cycl_id
3188: ,ben.lf_evt_ocrd_dt
3189: ,ben.audit_log_flag
3190: from ben_benefit_actions ben
3191: where ben.benefit_action_id = p_benefit_action_id;
3192: --
3193: l_effective_date date;
3194: l_proc varchar2(80) := g_package || '.do_multithread';
4703: if p_benefit_action_id is null then
4704: --
4705: -- A new request was submitted. Create a new benefit action.
4706: --
4707: ben_benefit_actions_api.create_benefit_actions
4708: (p_validate => FALSE
4709: ,p_benefit_action_id => g_parm.benefit_action_id
4710: ,p_process_date => l_effective_date
4711: ,p_mode_cd => p_mode
4876: --
4877: cursor c_tot_person_cm is
4878: select count(distinct bmi.person_id)
4879: from ben_batch_commu_info bmi,
4880: ben_benefit_actions bft
4881: where bft.request_id = p_concurrent_request_id
4882: and bft.benefit_action_id = bmi.benefit_action_id;
4883: --
4884: cursor c_tot_person_1_cm is
4883: --
4884: cursor c_tot_person_1_cm is
4885: select count(*)
4886: from ben_batch_commu_info bmi1,
4887: ben_benefit_actions bft
4888: where bft.request_id = p_concurrent_request_id
4889: and bft.benefit_action_id = bmi1.benefit_action_id
4890: and not exists ( select 1
4891: from ben_batch_commu_info bmi2
5000: cla.name cmbn_age_los_fctr,
5001: bft.date_from date_from,
5002: conc.user_concurrent_program_name conc_prog_name,
5003: fnd1.meaning
5004: from ben_benefit_actions bft,
5005: hr_lookups hr1,
5006: hr_lookups hr2,
5007: hr_lookups hr3,
5008: hr_lookups hr4,