[Home] [Help]
140: pil.lf_evt_ocrd_dt,
141: ler.typ_cd,
142: ler.ler_id
143: from ben_per_in_ler pil,
144: ben_ler_f ler
145: where pil.person_id = l_person_id
146: and pil.lf_evt_ocrd_dt
147: between l_from_ocrd_date
148: and l_to_ocrd_date
161: ) or
162: (p_abs_ler = 'Y' and
163: pil.ler_id in
164: (select ler.ler_id
165: from ben_ler_f ler
166: where ler.typ_cd = 'ABS'
167: and ler.lf_evt_oper_cd in ('START','END')
168: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
169: and ler.business_group_id = p_business_group_id
188: pil.lf_evt_ocrd_dt,
189: ler.typ_cd,
190: ler.ler_id
191: from ben_per_in_ler pil,
192: ben_ler_f ler
193: where pil.person_id = l_person_id
194: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
195: and pil.lf_evt_ocrd_dt
196: between l_ler_thread.lf_evt_ocrd_dt
221: cursor c_latest_ler is
222: select pil.per_in_ler_id,
223: ler.name
224: from ben_per_in_ler pil,
225: ben_ler_f ler
226: where pil.person_id = l_person_id
227: and pil.business_group_id+0 = p_business_group_id
228: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
229: and pil.ler_id = ler.ler_id
236: cursor c_latest_ler_abs is
237: select pil.per_in_ler_id,
238: ler.name
239: from ben_per_in_ler pil,
240: ben_ler_f ler
241: where pil.person_id = l_person_id
242: and pil.business_group_id+0 = p_business_group_id
243: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
244: and pil.ler_id = ler.ler_id
252: cursor c_latest_ler_cwb is
253: select pil.per_in_ler_id,
254: ler.name
255: from ben_per_in_ler pil,
256: ben_ler_f ler
257: where pil.person_id = l_person_id
258: and pil.business_group_id+0 = p_business_group_id
259: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
260: and pil.ler_id = ler.ler_id
268: cursor c_latest_ler_gsp is
269: select pil.per_in_ler_id,
270: ler.name
271: from ben_per_in_ler pil,
272: ben_ler_f ler
273: where pil.person_id = l_person_id
274: and pil.business_group_id+0 = p_business_group_id
275: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
276: and pil.ler_id = ler.ler_id
815: between ppf.effective_start_date
816: and ppf.effective_end_date
817: and exists (select null
818: from ben_per_in_ler pil
819: , ben_ler_f ler
820: where pil.lf_evt_ocrd_dt between l_from_ocrd_date
821: and l_to_ocrd_date
822: and pil.ler_id = ler.ler_id
823: and l_effective_date between ler.effective_start_date
899: from per_all_people_f ppf
900: where l_effective_date between ppf.effective_start_date and ppf.effective_end_date
901: and exists (select null
902: from ben_per_in_ler pil,
903: ben_ler_f ler
904: where ler.ler_id = pil.ler_id
905: and ler.typ_cd = 'COMP'
906: and l_effective_date
907: between ler.effective_start_date
923: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
924: l_object_version_number ben_benefit_actions.object_version_number%type;
925: l_person_id per_people_f.person_id%type;
926: l_person_action_id ben_person_actions.person_action_id%type;
927: l_ler_id ben_ler_f.ler_id%type;
928: l_range_id ben_batch_ranges.range_id%type;
929: l_chunk_size number := 20;
930: l_threads number := 1;
931: l_start_person_action_id number := 0;