APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_PER_IN_LER

Line 68: ben_per_in_ler pil

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

Line 423: l_object_version_number ben_per_in_ler.object_version_number%TYPE;

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

Line 521: from ben_per_in_ler pil,

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

Line 590: from ben_per_in_ler pil,

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

Line 1976: from ben_per_in_ler pil,

1972: cursor c_pil
1973: is
1974: select distinct pil.person_id
1975: ,pil.per_in_ler_id
1976: from ben_per_in_ler pil,
1977: per_all_people_f per,
1978: ben_ler_f ler
1979: where pil.business_group_id = p_business_group_id
1980: and pil.per_in_ler_stat_cd = 'STRTD'

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

2195: --
2196: delete from ben_batch_ranges
2197: where benefit_action_id = l_benefit_action_id;
2198: --
2199: -- Loop through rows in ben_per_in_ler_f based on the parameters passed and
2200: -- create person actions for the selected people.
2201: --
2202: open c_pil;
2203: fetch c_pil bulk collect into l_perid_va,l_pilid_va;

Line 2484: from ben_per_in_ler pil,

2480: is
2481: --
2482: cursor c_get_future_per_in_ler is
2483: select null
2484: from ben_per_in_ler pil,
2485: ben_ler_f ler
2486: where pil.lf_evt_ocrd_dt > p_lf_evt_ocrd_dt
2487: and pil.person_id = p_person_id
2488: and ler.ler_id = pil.ler_id

Line 2522: from ben_per_in_ler pil

2518: -- Temporary until we add the reopen date.
2519: --
2520: cursor c_get_strtd_dt is
2521: select pil.*
2522: from ben_per_in_ler pil
2523: where pil.per_in_ler_id = p_per_in_ler_id
2524: and pil.business_group_id = p_business_group_id;
2525: --
2526: -- Bug(2300866):Check cursor for Reopening Life Events

Line 2562: l_object_version_number ben_per_in_ler.object_version_number%type;

2558: --
2559: --
2560: l_proc varchar2(80) := g_package||'.reopen_single_life_event';
2561: l_exists varchar2(1);
2562: l_object_version_number ben_per_in_ler.object_version_number%type;
2563: l_dummy_dt date;
2564: l_procd_dt date;
2565: l_strtd_dt date;
2566: l_voidd_dt date;