[Home] [Help]
135: pil.lf_evt_ocrd_dt,
136: ler.typ_cd,
137: ler.ler_id
138: from ben_per_in_ler pil,
139: ben_ler_f ler
140: where pil.person_id = l_person_id
141: and pil.lf_evt_ocrd_dt
142: between l_from_ocrd_date
143: and l_to_ocrd_date
156: ) or
157: (p_abs_ler = 'Y' and
158: pil.ler_id in
159: (select ler.ler_id
160: from ben_ler_f ler
161: where ler.typ_cd = 'ABS'
162: and ler.lf_evt_oper_cd in ('START','END')
163: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
164: and ler.business_group_id = p_business_group_id
183: pil.lf_evt_ocrd_dt,
184: ler.typ_cd,
185: ler.ler_id
186: from ben_per_in_ler pil,
187: ben_ler_f ler
188: where pil.person_id = l_person_id
189: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
190: and pil.lf_evt_ocrd_dt
191: between l_ler_thread.lf_evt_ocrd_dt
216: cursor c_latest_ler is
217: select pil.per_in_ler_id,
218: ler.name
219: from ben_per_in_ler pil,
220: ben_ler_f ler
221: where pil.person_id = l_person_id
222: and pil.business_group_id+0 = p_business_group_id
223: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
224: and pil.ler_id = ler.ler_id
231: cursor c_latest_ler_abs is
232: select pil.per_in_ler_id,
233: ler.name
234: from ben_per_in_ler pil,
235: ben_ler_f ler
236: where pil.person_id = l_person_id
237: and pil.business_group_id+0 = p_business_group_id
238: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
239: and pil.ler_id = ler.ler_id
247: cursor c_latest_ler_cwb is
248: select pil.per_in_ler_id,
249: ler.name
250: from ben_per_in_ler pil,
251: ben_ler_f ler
252: where pil.person_id = l_person_id
253: and pil.business_group_id+0 = p_business_group_id
254: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
255: and pil.ler_id = ler.ler_id
263: cursor c_latest_ler_gsp is
264: select pil.per_in_ler_id,
265: ler.name
266: from ben_per_in_ler pil,
267: ben_ler_f ler
268: where pil.person_id = l_person_id
269: and pil.business_group_id+0 = p_business_group_id
270: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
271: and pil.ler_id = ler.ler_id
789: between ppf.effective_start_date
790: and ppf.effective_end_date
791: and exists (select null
792: from ben_per_in_ler pil
793: , ben_ler_f ler
794: where pil.lf_evt_ocrd_dt between l_from_ocrd_date
795: and l_to_ocrd_date
796: and pil.ler_id = ler.ler_id
797: and l_effective_date between ler.effective_start_date
873: from per_all_people_f ppf
874: where l_effective_date between ppf.effective_start_date and ppf.effective_end_date
875: and exists (select null
876: from ben_per_in_ler pil,
877: ben_ler_f ler
878: where ler.ler_id = pil.ler_id
879: and ler.typ_cd = 'COMP'
880: and l_effective_date
881: between ler.effective_start_date
897: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
898: l_object_version_number ben_benefit_actions.object_version_number%type;
899: l_person_id per_people_f.person_id%type;
900: l_person_action_id ben_person_actions.person_action_id%type;
901: l_ler_id ben_ler_f.ler_id%type;
902: l_range_id ben_batch_ranges.range_id%type;
903: l_chunk_size number := 20;
904: l_threads number := 1;
905: l_start_person_action_id number := 0;