APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_PER_IN_LER

Line 67: ben_per_in_ler pil

63: cursor c1 (c_prtt_enrt_rslt_id number)
64: is
65: select ecd.dpnt_person_id, ecd.cvg_strt_dt, ecd.cvg_thru_dt
66: from ben_elig_cvrd_dpnt_f ecd,
67: ben_per_in_ler pil
68: where ecd.prtt_enrt_rslt_id is not NULL
69: and ecd.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
70: and ecd.business_group_id = p_business_group_id
71: and p_effective_date between effective_start_date

Line 422: l_object_version_number ben_per_in_ler.object_version_number%TYPE;

418: is
419: --
420: l_effective_start_date date;
421: l_effective_end_date date;
422: l_object_version_number ben_per_in_ler.object_version_number%TYPE;
423: l_proc varchar2(80):=g_package||'.update_per_in_ler';
424: l_actn varchar2(80);
425: l_dummy_dt date;
426: l_procd_dt date;

Line 520: from ben_per_in_ler pil,

516: ,pil.ler_id
517: ,pil.lf_evt_ocrd_dt
518: ,ppf.business_group_id
519: ,pil.per_in_ler_stat_cd
520: from ben_per_in_ler pil,
521: per_all_people_f ppf,
522: ben_ler_f ler
523: where pil.per_in_ler_id = p_per_in_ler_id
524: and pil.business_group_id = p_business_group_id

Line 589: from ben_per_in_ler pil,

585: and vlv.number_value = p_per_in_ler_id;
586: --
587: cursor c_ler is
588: select null
589: from ben_per_in_ler pil,
590: ben_ler_f ler
591: where pil.per_in_ler_id = p_per_in_ler_id
592: and pil.business_group_id = p_business_group_id
593: and ler.ler_id = pil.ler_id

Line 1936: from ben_per_in_ler pil,

1932: cursor c_pil
1933: is
1934: select distinct pil.person_id
1935: ,pil.per_in_ler_id
1936: from ben_per_in_ler pil,
1937: per_all_people_f per,
1938: ben_ler_f ler
1939: where pil.business_group_id = p_business_group_id
1940: and pil.per_in_ler_stat_cd = 'STRTD'

Line 2159: -- Loop through rows in ben_per_in_ler_f based on the parameters passed and

2155: --
2156: delete from ben_batch_ranges
2157: where benefit_action_id = l_benefit_action_id;
2158: --
2159: -- Loop through rows in ben_per_in_ler_f based on the parameters passed and
2160: -- create person actions for the selected people.
2161: --
2162: open c_pil;
2163: fetch c_pil bulk collect into l_perid_va,l_pilid_va;

Line 2444: from ben_per_in_ler pil,

2440: is
2441: --
2442: cursor c_get_future_per_in_ler is
2443: select null
2444: from ben_per_in_ler pil,
2445: ben_ler_f ler
2446: where pil.lf_evt_ocrd_dt > p_lf_evt_ocrd_dt
2447: and pil.person_id = p_person_id
2448: and ler.ler_id = pil.ler_id

Line 2482: from ben_per_in_ler pil

2478: -- Temporary until we add the reopen date.
2479: --
2480: cursor c_get_strtd_dt is
2481: select pil.*
2482: from ben_per_in_ler pil
2483: where pil.per_in_ler_id = p_per_in_ler_id
2484: and pil.business_group_id = p_business_group_id;
2485: --
2486: -- Bug(2300866):Check cursor for Reopening Life Events

Line 2522: l_object_version_number ben_per_in_ler.object_version_number%type;

2518: --
2519: --
2520: l_proc varchar2(80) := g_package||'.reopen_single_life_event';
2521: l_exists varchar2(1);
2522: l_object_version_number ben_per_in_ler.object_version_number%type;
2523: l_dummy_dt date;
2524: l_procd_dt date;
2525: l_strtd_dt date;
2526: l_voidd_dt date;