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 147: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161

143: pen.SSPNDD_FLAG,
144: pen.UOM
145: from ben_prtt_enrt_rslt_f pen,
146: ben_per_in_ler pil,
147: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161
148: where pil.per_in_ler_id = c_bckdt_per_in_ler_id
149: and pil.person_id = c_person_id
150: and pil.per_in_ler_id = pen.per_in_ler_id
151: and pil.per_in_ler_id = pel.per_in_ler_id

Line 278: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161

274: pen.SSPNDD_FLAG,
275: pen.UOM
276: from ben_le_clsn_n_rstr pen,
277: ben_per_in_ler pil,
278: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161
279: where pil.per_in_ler_id = c_bckdt_per_in_ler_id
280: and pil.person_id = c_person_id
281: and pil.per_in_ler_id = pel.per_in_ler_id
282: and ((pel.pgm_id is null and c_pgm_id is null) or

Line 358: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161

354: pen.RPLCS_SSPNDD_RSLT_ID,
355: pen.SSPNDD_FLAG
356: from ben_prtt_enrt_rslt_f pen,
357: ben_per_in_ler pil,
358: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161
359: where pil.per_in_ler_id = c_bckdt_per_in_ler_id
360: and pil.person_id = c_person_id
361: and pil.per_in_ler_id = pen.per_in_ler_id
362: and pil.per_in_ler_id = pel.per_in_ler_id

Line 428: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161

424: pen.RPLCS_SSPNDD_RSLT_ID,
425: pen.SSPNDD_FLAG
426: from ben_le_clsn_n_rstr pen,
427: ben_per_in_ler pil,
428: ben_pil_elctbl_chc_popl pel --Added for Bug 4423161
429: where pil.per_in_ler_id = c_bckdt_per_in_ler_id
430: and pil.person_id = c_person_id
431: and pil.per_in_ler_id = pel.per_in_ler_id
432: and (pel.dflt_asnd_dt is null and

Line 2496: ben_pil_elctbl_chc_popl pel,

2492: --
2493: cursor c_bckdt_epe_cnt is
2494: select count(*)
2495: from ben_elig_per_elctbl_chc epe,
2496: ben_pil_elctbl_chc_popl pel,
2497: ben_per_in_ler pil
2498: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
2499: and pil.person_id = p_person_id
2500: and pil.per_in_ler_id = pel.per_in_ler_id

Line 2510: ben_pil_elctbl_chc_popl pel,

2506: --
2507: cursor c_curr_epe_cnt is
2508: select count(*)
2509: from ben_elig_per_elctbl_chc epe,
2510: ben_pil_elctbl_chc_popl pel,
2511: ben_per_in_ler pil
2512: where pil.per_in_ler_id = p_per_in_ler_id
2513: and pil.person_id = p_person_id
2514: and pil.per_in_ler_id = pel.per_in_ler_id

Line 2533: ben_pil_elctbl_chc_popl pel,

2529: --
2530: cursor c_bckdt_epe_dat is
2531: select epe.*
2532: from ben_elig_per_elctbl_chc epe,
2533: ben_pil_elctbl_chc_popl pel,
2534: ben_per_in_ler pil
2535: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
2536: and pil.person_id = p_person_id
2537: and pil.per_in_ler_id = pel.per_in_ler_id

Line 2547: ben_pil_elctbl_chc_popl pel,

2543: --
2544: cursor c_curr_epe_dat is
2545: select epe.*
2546: from ben_elig_per_elctbl_chc epe,
2547: ben_pil_elctbl_chc_popl pel,
2548: ben_per_in_ler pil
2549: where pil.per_in_ler_id = p_per_in_ler_id
2550: and pil.person_id = p_person_id
2551: and pil.per_in_ler_id = pel.per_in_ler_id

Line 2917: cursor c_ben_pil_elctbl_chc_popl is

2913: ) is
2914: --
2915: l_proc varchar2(72) := g_package||'.extend_enrt_date';
2916: --
2917: cursor c_ben_pil_elctbl_chc_popl is
2918: select pel.*
2919: from ben_pil_elctbl_chc_popl pel,
2920: ben_per_in_ler pil
2921: where pil.per_in_ler_id = p_per_in_ler_id

Line 2919: from ben_pil_elctbl_chc_popl pel,

2915: l_proc varchar2(72) := g_package||'.extend_enrt_date';
2916: --
2917: cursor c_ben_pil_elctbl_chc_popl is
2918: select pel.*
2919: from ben_pil_elctbl_chc_popl pel,
2920: ben_per_in_ler pil
2921: where pil.per_in_ler_id = p_per_in_ler_id
2922: and pil.business_group_id = p_business_group_id
2923: and pel.per_in_ler_id = pil.per_in_ler_id

Line 2935: for pel_rec in c_ben_pil_elctbl_chc_popl

2931: -- Only extend the dates if the pel status was STRTD
2932: --
2933: if g_bckdt_pil_prvs_stat_cd = 'STRTD' then
2934: --
2935: for pel_rec in c_ben_pil_elctbl_chc_popl
2936: loop
2937: --
2938: -- Give person same enrollment period starting from now
2939: -- Or if the enrollment period has not yet started then

Line 2952: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl (

2948: --
2949: -- Update pel now
2950: --
2951:
2952: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl (
2953: p_validate => false
2954: ,p_pil_elctbl_chc_popl_id => pel_rec.pil_elctbl_chc_popl_id
2955: ,p_object_version_number => pel_rec.object_version_number
2956: ,p_effective_date => p_effective_date

Line 6273: ben_pil_elctbl_chc_popl pel

6269: to_date('31-12-4712','DD-MM-YYYY') enrt_cvg_end_dt,
6270: pel.dflt_enrt_dt
6271: from ben_elig_per_elctbl_chc epe,
6272: ben_per_in_ler pil,
6273: ben_pil_elctbl_chc_popl pel
6274: where epe.per_in_ler_id = p_per_in_ler_id
6275: and epe.business_group_id = p_business_group_id
6276: and epe.pl_id = cp_pl_id
6277: and nvl(epe.pgm_id, -1) = nvl(cp_pgm_id, -1)

Line 9433: from ben_pil_elctbl_chc_popl pel

9429: pel.pl_id,
9430: pel.reinstate_cd,
9431: pel.reinstate_ovrdn_cd,
9432: pel.enrt_perd_strt_dt
9433: from ben_pil_elctbl_chc_popl pel
9434: where pel.per_in_ler_id = c_per_in_ler_id
9435: and ((pel.pgm_id = c_pgm_id and
9436: pel.pl_id is null ) or
9437: (pel.pl_id = c_pl_id and

Line 9936: from ben_pil_elctbl_chc_popl pel

9932: pel.pl_id,
9933: pel.reinstate_cd,
9934: pel.reinstate_ovrdn_cd,
9935: pel.enrt_perd_strt_dt
9936: from ben_pil_elctbl_chc_popl pel
9937: where pel.per_in_ler_id = p_per_in_ler_id;
9938: --
9939: cursor c_multiple_rate is
9940: select null

Line 10063: (select '1' from ben_pil_elctbl_chc_popl pel

10059:
10060: /*Bug 13711703 */
10061: cursor c_reopen_le is
10062: select '1' from dual where exists
10063: (select '1' from ben_pil_elctbl_chc_popl pel
10064: where pel.per_in_ler_id = p_per_in_ler_id
10065: and pel.reopen_le_on_reprocess = 'Y');
10066: l_reopen_le_on_reprocess varchar2(30);
10067:

Line 10161: select * from ben_pil_elctbl_chc_popl pel

10157: */
10158:
10159: /*Bug 13079111 */
10160: cursor c_popl_rec(c_per_in_ler_id number,p_pgm_id number,p_pl_id number) is
10161: select * from ben_pil_elctbl_chc_popl pel
10162: where per_in_ler_id = c_per_in_ler_id
10163: --Bug 13940072 added pgm_id and pl_id check to fetch correct record
10164: and (
10165: (p_pl_id is null and pgm_id = p_pgm_id) or

Line 10473: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl

10469: open c_popl_rec(p_per_in_ler_id,r_pel.pgm_id,r_pel.pl_id);
10470: fetch c_popl_rec into l_popl_rec;
10471: close c_popl_rec;
10472: hr_utility.set_location('Setting elections made date to old date ',400);
10473: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl
10474: (p_validate => p_validate
10475: ,p_pil_elctbl_chc_popl_id => l_popl_rec.PIL_ELCTBL_CHC_POPL_ID
10476: ,p_elcns_made_dt => l_ele_date
10477: ,p_object_version_number => l_popl_rec.object_version_number

Line 10936: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl

10932: open c_popl_rec(p_per_in_ler_id,r_pel.pgm_id,r_pel.pl_id);
10933: fetch c_popl_rec into l_popl_rec;
10934: close c_popl_rec;
10935: hr_utility.set_location('Setting elections made date to old date ',400);
10936: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl
10937: (p_validate => p_validate
10938: ,p_pil_elctbl_chc_popl_id => l_popl_rec.PIL_ELCTBL_CHC_POPL_ID
10939: ,p_elcns_made_dt => l_ele_date
10940: ,p_object_version_number => l_popl_rec.object_version_number

Line 11112: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl

11108: l_ele_date := l_popl_rec.elcns_made_dt;
11109: close c_popl_rec;
11110:
11111: hr_utility.set_location('Setting elections made date to old date ',400);
11112: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl
11113: (p_validate => p_validate
11114: ,p_pil_elctbl_chc_popl_id => l_popl_rec.PIL_ELCTBL_CHC_POPL_ID
11115: ,p_elcns_made_dt => l_ele_date
11116: ,p_object_version_number => l_popl_rec.object_version_number

Line 11585: ben_pil_elctbl_chc_popl pel

11581: to_date('31-12-4712','DD-MM-YYYY') enrt_cvg_end_dt,
11582: pel.dflt_enrt_dt
11583: from ben_elig_per_elctbl_chc epe,
11584: ben_per_in_ler pil,
11585: ben_pil_elctbl_chc_popl pel
11586: where epe.per_in_ler_id = cp_per_in_ler_id
11587: and epe.business_group_id = p_business_group_id
11588: and epe.pl_id = cp_pl_id
11589: and nvl(epe.pgm_id, -1) = nvl(cp_pgm_id, -1)