eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 140: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161

136: pen.SSPNDD_FLAG,
137: pen.UOM
138: from ben_prtt_enrt_rslt_f pen,
139: ben_per_in_ler pil,
140: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161
141: where pil.per_in_ler_id = c_bckdt_per_in_ler_id
142: and pil.person_id = c_person_id
143: and pil.per_in_ler_id = pen.per_in_ler_id
144: and pil.per_in_ler_id = pel.per_in_ler_id

Line 270: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161

266: pen.SSPNDD_FLAG,
267: pen.UOM
268: from ben_le_clsn_n_rstr pen,
269: ben_per_in_ler pil,
270: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161
271: where pil.per_in_ler_id = c_bckdt_per_in_ler_id
272: and pil.person_id = c_person_id
273: and pil.per_in_ler_id = pel.per_in_ler_id
274: and ((pel.pgm_id is null and c_pgm_id is null) or

Line 2266: ben_pil_elctbl_chc_popl pel,

2262: --
2263: cursor c_bckdt_epe_cnt is
2264: select count(*)
2265: from ben_elig_per_elctbl_chc epe,
2266: ben_pil_elctbl_chc_popl pel,
2267: ben_per_in_ler pil
2268: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
2269: and pil.person_id = p_person_id
2270: and pil.per_in_ler_id = pel.per_in_ler_id

Line 2280: ben_pil_elctbl_chc_popl pel,

2276: --
2277: cursor c_curr_epe_cnt is
2278: select count(*)
2279: from ben_elig_per_elctbl_chc epe,
2280: ben_pil_elctbl_chc_popl pel,
2281: ben_per_in_ler pil
2282: where pil.per_in_ler_id = p_per_in_ler_id
2283: and pil.person_id = p_person_id
2284: and pil.per_in_ler_id = pel.per_in_ler_id

Line 2303: ben_pil_elctbl_chc_popl pel,

2299: --
2300: cursor c_bckdt_epe_dat is
2301: select epe.*
2302: from ben_elig_per_elctbl_chc epe,
2303: ben_pil_elctbl_chc_popl pel,
2304: ben_per_in_ler pil
2305: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
2306: and pil.person_id = p_person_id
2307: and pil.per_in_ler_id = pel.per_in_ler_id

Line 2317: ben_pil_elctbl_chc_popl pel,

2313: --
2314: cursor c_curr_epe_dat is
2315: select epe.*
2316: from ben_elig_per_elctbl_chc epe,
2317: ben_pil_elctbl_chc_popl pel,
2318: ben_per_in_ler pil
2319: where pil.per_in_ler_id = p_per_in_ler_id
2320: and pil.person_id = p_person_id
2321: and pil.per_in_ler_id = pel.per_in_ler_id

Line 2687: cursor c_ben_pil_elctbl_chc_popl is

2683: ) is
2684: --
2685: l_proc varchar2(72) := g_package||'.extend_enrt_date';
2686: --
2687: cursor c_ben_pil_elctbl_chc_popl is
2688: select pel.*
2689: from ben_pil_elctbl_chc_popl pel,
2690: ben_per_in_ler pil
2691: where pil.per_in_ler_id = p_per_in_ler_id

Line 2689: from ben_pil_elctbl_chc_popl pel,

2685: l_proc varchar2(72) := g_package||'.extend_enrt_date';
2686: --
2687: cursor c_ben_pil_elctbl_chc_popl is
2688: select pel.*
2689: from ben_pil_elctbl_chc_popl pel,
2690: ben_per_in_ler pil
2691: where pil.per_in_ler_id = p_per_in_ler_id
2692: and pil.business_group_id = p_business_group_id
2693: and pel.per_in_ler_id = pil.per_in_ler_id

Line 2705: for pel_rec in c_ben_pil_elctbl_chc_popl

2701: -- Only extend the dates if the pel status was STRTD
2702: --
2703: if g_bckdt_pil_prvs_stat_cd = 'STRTD' then
2704: --
2705: for pel_rec in c_ben_pil_elctbl_chc_popl
2706: loop
2707: --
2708: -- Give person same enrollment period starting from now
2709: -- Or if the enrollment period has not yet started then

Line 2722: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl (

2718: --
2719: -- Update pel now
2720: --
2721:
2722: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl (
2723: p_validate => false
2724: ,p_pil_elctbl_chc_popl_id => pel_rec.pil_elctbl_chc_popl_id
2725: ,p_object_version_number => pel_rec.object_version_number
2726: ,p_effective_date => p_effective_date

Line 5882: ben_pil_elctbl_chc_popl pel

5878: to_date('31-12-4712','DD-MM-YYYY') enrt_cvg_end_dt,
5879: pel.dflt_enrt_dt
5880: from ben_elig_per_elctbl_chc epe,
5881: ben_per_in_ler pil,
5882: ben_pil_elctbl_chc_popl pel
5883: where epe.per_in_ler_id = p_per_in_ler_id
5884: and epe.business_group_id = p_business_group_id
5885: and epe.pl_id = cp_pl_id
5886: and nvl(epe.pgm_id, -1) = nvl(cp_pgm_id, -1)

Line 8627: from ben_pil_elctbl_chc_popl pel

8623: pel.pl_id,
8624: pel.reinstate_cd,
8625: pel.reinstate_ovrdn_cd,
8626: pel.enrt_perd_strt_dt
8627: from ben_pil_elctbl_chc_popl pel
8628: where pel.per_in_ler_id = c_per_in_ler_id
8629: and ((pel.pgm_id = c_pgm_id and
8630: pel.pl_id is null ) or
8631: (pel.pl_id = c_pl_id and

Line 9130: from ben_pil_elctbl_chc_popl pel

9126: pel.pl_id,
9127: pel.reinstate_cd,
9128: pel.reinstate_ovrdn_cd,
9129: pel.enrt_perd_strt_dt
9130: from ben_pil_elctbl_chc_popl pel
9131: where pel.per_in_ler_id = p_per_in_ler_id;
9132: --
9133: cursor c_multiple_rate is
9134: select null

Line 10104: ben_pil_elctbl_chc_popl pel

10100: to_date('31-12-4712','DD-MM-YYYY') enrt_cvg_end_dt,
10101: pel.dflt_enrt_dt
10102: from ben_elig_per_elctbl_chc epe,
10103: ben_per_in_ler pil,
10104: ben_pil_elctbl_chc_popl pel
10105: where epe.per_in_ler_id = cp_per_in_ler_id
10106: and epe.business_group_id = p_business_group_id
10107: and epe.pl_id = cp_pl_id
10108: and nvl(epe.pgm_id, -1) = nvl(cp_pgm_id, -1)