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_MANAGE_LIFE_EVENTS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 2832: from ben_pil_elctbl_chc_popl

2828:
2829: --
2830: cursor c_pil_popl is
2831: select *
2832: from ben_pil_elctbl_chc_popl
2833: where per_in_ler_id = p_per_in_ler_id;
2834: --
2835: --bug#2718215
2836: cursor c_result_pgm (p_pgm_id number) is

Line 2916: update ben_pil_elctbl_chc_popl

2912: --
2913: if i.pgm_id = ben_manage_life_events.g_pil_popl_tbl(j).pgm_id or
2914: i.pl_id = ben_manage_life_events.g_pil_popl_tbl(j).pl_id then
2915: --
2916: update ben_pil_elctbl_chc_popl
2917: set elcns_made_dt = ben_manage_life_events.g_pil_popl_tbl(j).elcns_made_dt
2918: where pil_elctbl_chc_popl_id = i.pil_elctbl_chc_popl_id;
2919: --
2920: --

Line 2931: update ben_pil_elctbl_chc_popl

2927: if i.pgm_id is not null then
2928: open c_result_pgm (i.pgm_id);
2929: fetch c_result_pgm into l_effective_start_date;
2930: if c_result_pgm%found then
2931: update ben_pil_elctbl_chc_popl
2932: set elcns_made_dt = l_effective_start_date
2933: where pil_elctbl_chc_popl_id = i.pil_elctbl_chc_popl_id;
2934: end if;
2935: close c_result_pgm;

Line 2940: update ben_pil_elctbl_chc_popl

2936: elsif i.pl_id is not null then
2937: open c_result_pln (i.pl_id);
2938: fetch c_result_pln into l_effective_start_date;
2939: if c_result_pln%found then
2940: update ben_pil_elctbl_chc_popl
2941: set elcns_made_dt = l_effective_start_date
2942: where pil_elctbl_chc_popl_id = i.pil_elctbl_chc_popl_id;
2943: end if;
2944: close c_result_pln;

Line 3378: ben_pil_elctbl_chc_popl mgr_pel_0,

3374: p_lf_evt_ocrd_dt date,
3375: p_business_group_id number) is
3376: select unique pel_0.mgr_pil_elctbl_chc_popl_id
3377: from ben_cwb_hrchy pel_0,
3378: ben_pil_elctbl_chc_popl mgr_pel_0,
3379: ben_per_in_ler pil_0
3380: where
3381: mgr_pel_0.pil_elctbl_chc_popl_id = pel_0.mgr_pil_elctbl_chc_popl_id
3382: and mgr_pel_0.per_in_ler_id = pil_0.per_in_ler_id

Line 3392: ben_pil_elctbl_chc_popl mgr_pel,

3388: and pel_0.lvl_num > 0
3389: and pel_0.mgr_pil_elctbl_chc_popl_id not in
3390: ( select mgr_pel.pil_elctbl_chc_popl_id
3391: from ben_cwb_hrchy hrh,
3392: ben_pil_elctbl_chc_popl mgr_pel,
3393: ben_per_in_ler pil
3394: where hrh.mgr_pil_elctbl_chc_popl_id =
3395: hrh.emp_pil_elctbl_chc_popl_id
3396: and mgr_pel.pil_elctbl_chc_popl_id = hrh.mgr_pil_elctbl_chc_popl_id

Line 3416: ben_pil_elctbl_chc_popl pel ,

3412: cwb.emp_pil_elctbl_chc_popl_id,
3413: pel.ws_mgr_id
3414: from
3415: ben_cwb_hrchy cwb,
3416: ben_pil_elctbl_chc_popl pel ,
3417: ben_per_in_ler pil
3418: where
3419: cwb.mgr_pil_elctbl_chc_popl_id = -1
3420: and pel.pil_elctbl_chc_popl_id = cwb.emp_pil_elctbl_chc_popl_id

Line 3442: ben_pil_elctbl_chc_popl pel,

3438: pil.lf_evt_ocrd_dt,
3439: pil.ler_id,
3440: pil.business_group_id
3441: from
3442: ben_pil_elctbl_chc_popl pel,
3443: ben_per_in_ler pil
3444: where
3445: pel.per_in_ler_id = pil.per_in_ler_id
3446: and pel.pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id

Line 3466: from ben_pil_elctbl_chc_popl pel,

3462: p_ler_id number,
3463: p_business_group_id number) is
3464: select pel.ws_mgr_id,
3465: pel.pil_elctbl_chc_popl_id
3466: from ben_pil_elctbl_chc_popl pel,
3467: ben_per_in_ler pil
3468: where pel.per_in_ler_id = pil.per_in_ler_id
3469: and pel.pl_id = p_pl_id
3470: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 3542: from ben_pil_elctbl_chc_popl pel ,

3538: -- Bug 2541072 : Do not consider all per in ler's.
3539: --
3540: and exists
3541: (select null
3542: from ben_pil_elctbl_chc_popl pel ,
3543: ben_per_in_ler pil
3544: where pel.pil_elctbl_chc_popl_id = cwh.emp_pil_elctbl_chc_popl_id
3545: and pel.per_in_ler_id = pil.per_in_ler_id
3546: and pil.per_in_ler_stat_cd = 'STRTD'

Line 3577: from ben_pil_elctbl_chc_popl pel ,

3573: -- Bug 2541072 : Do not consider all per in ler's.
3574: --
3575: and exists
3576: (select null
3577: from ben_pil_elctbl_chc_popl pel ,
3578: ben_per_in_ler pil
3579: where pel.pil_elctbl_chc_popl_id = cwh.emp_pil_elctbl_chc_popl_id
3580: and pel.per_in_ler_id = pil.per_in_ler_id
3581: and pil.per_in_ler_stat_cd = 'STRTD'

Line 3749: from ben_pil_elctbl_chc_popl pel,

3745: --
3746: delete from ben_cwb_hrchy
3747: where emp_pil_elctbl_chc_popl_id in (
3748: select pel.pil_elctbl_chc_popl_id
3749: from ben_pil_elctbl_chc_popl pel,
3750: ben_per_in_ler pil
3751: where pel.pl_id = lv_pl_id
3752: and pil.lf_evt_ocrd_dt = lv_lf_evt_ocrd_dt
3753: and pil.per_in_ler_id = pel.per_in_ler_id

Line 3759: from ben_pil_elctbl_chc_popl pel,

3755: --
3756: delete from ben_cwb_hrchy
3757: where mgr_pil_elctbl_chc_popl_id in (
3758: select pel.pil_elctbl_chc_popl_id
3759: from ben_pil_elctbl_chc_popl pel,
3760: ben_per_in_ler pil
3761: where pel.pl_id = lv_pl_id
3762: and pil.lf_evt_ocrd_dt = lv_lf_evt_ocrd_dt
3763: and pil.per_in_ler_id = pel.per_in_ler_id

Line 4251: from ben_pil_elctbl_chc_popl pel,

4247: pel.acty_ref_perd_cd,
4248: pel.business_group_id per_business_group_id,
4249: per.business_group_id mgr_business_group_id,
4250: pel.ws_mgr_id
4251: from ben_pil_elctbl_chc_popl pel,
4252: per_all_people_f per
4253: where pel.per_in_ler_id = cv_per_in_ler_id
4254: and pel.ws_mgr_id = per.person_id (+)
4255: and l_effective_date between effective_start_date

Line 4272: ben_pil_elctbl_chc_popl pel,

4268: pel.acty_ref_perd_cd,
4269: epe.business_group_id per_business_group_id,
4270: per.business_group_id mgr_business_group_id
4271: from ben_elig_per_elctbl_chc epe,
4272: ben_pil_elctbl_chc_popl pel,
4273: per_all_people_f per
4274: where epe.per_in_ler_id = cv_per_in_ler_id
4275: and epe.per_in_ler_id = pel.per_in_ler_id
4276: and epe.pl_id = pel.pl_id

Line 4788: ben_pil_elctbl_chc_popl pel,

4784: pel.acty_ref_perd_cd,
4785: epe.business_group_id per_business_group_id,
4786: per.business_group_id mgr_business_group_id
4787: from ben_elig_per_elctbl_chc epe,
4788: ben_pil_elctbl_chc_popl pel,
4789: per_all_people_f per
4790: where epe.per_in_ler_id = cv_per_in_ler_id
4791: and epe.per_in_ler_id = pel.per_in_ler_id
4792: and epe.pl_id = pel.pl_id

Line 5405: from ben_pil_elctbl_chc_popl

5401:
5402: cursor c_popl is
5403: select pil_elctbl_chc_popl_id,
5404: object_version_number
5405: from ben_pil_elctbl_chc_popl
5406: where per_in_ler_id = l_pil_rec.per_in_ler_id;
5407: l_popl_rec c_popl%rowtype;
5408:
5409: l_package varchar2(80);

Line 5429: ben_Pil_Elctbl_chc_Popl_api.delete_Pil_Elctbl_chc_Popl

5425: if c_popl%notfound then
5426: exit;
5427: end if;
5428:
5429: ben_Pil_Elctbl_chc_Popl_api.delete_Pil_Elctbl_chc_Popl
5430: (p_pil_elctbl_chc_popl_id => l_popl_rec.pil_elctbl_chc_popl_id,
5431: p_object_version_number => l_popl_rec.object_version_number,
5432: p_effective_date => p_effective_date);
5433:

Line 7406: from ben_pil_elctbl_chc_popl pel

7402: l_package varchar2(80) := g_package||'.rebuild_heirarchy' ;
7403: -- Bug 2574791
7404: cursor c_pel is
7405: select pel.pl_id, pil.lf_evt_ocrd_dt, pel.business_group_id
7406: from ben_pil_elctbl_chc_popl pel
7407: ,ben_per_in_ler pil
7408: where pel.per_in_ler_id = pil.per_in_ler_id
7409: and pel.pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id;
7410: --

Line 10149: from ben_pil_elctbl_chc_popl popl

10145: --
10146: cursor c_pil_elctbl_chc_popl (p_per_in_ler_id in number) is
10147: select popl.pil_elctbl_chc_popl_id,
10148: popl.object_version_number
10149: from ben_pil_elctbl_chc_popl popl
10150: where per_in_ler_id = p_per_in_ler_id
10151: and not exists
10152: (select null
10153: from ben_elig_per_elctbl_chc epe

Line 10159: from ben_pil_elctbl_chc_popl popl

10155: and elctbl_flag = 'Y');
10156: --
10157: cursor c_pil (p_per_in_ler_id number, p_pgm_id number, p_pl_id number) is
10158: select 'Y'
10159: from ben_pil_elctbl_chc_popl popl
10160: where per_in_ler_id = p_per_in_ler_id
10161: and (popl.pgm_id = p_pgm_id or
10162: popl.pl_id = p_pl_id);
10163: --

Line 10277: from ben_pil_elctbl_chc_popl pel

10273: from ben_elig_per_elctbl_chc epe
10274: where epe.per_in_ler_id = p_per_in_ler_id
10275: and epe.pil_elctbl_chc_popl_id in
10276: (select pel.pil_elctbl_chc_popl_id
10277: from ben_pil_elctbl_chc_popl pel
10278: where pel.per_in_ler_id = p_per_in_ler_id
10279: and not exists
10280: (select null
10281: from ben_elig_per_elctbl_chc epe2

Line 10591: from ben_pil_elctbl_chc_popl pel

10587: --
10588: -- Defer ENH.
10589: cursor c_pel_defer(p_pgm_id number,p_per_in_ler_id in number) is
10590: select pel.*
10591: from ben_pil_elctbl_chc_popl pel
10592: where pel.pgm_id = p_pgm_id
10593: and pel.pl_id is null
10594: and pel.pil_elctbl_popl_stat_cd not in ('VOIDD','BCKDT')
10595: and pel.per_in_ler_id = p_per_in_ler_id;

Line 10602: from ben_pil_elctbl_chc_popl pel

10598: --
10599: cursor c_pel_pnip_defer (p_pl_id number,p_per_in_ler_id in number) is
10600: --
10601: select pel.*
10602: from ben_pil_elctbl_chc_popl pel
10603: where pel.pl_id = p_pl_id
10604: and pel.pgm_id is null
10605: and pel.pil_elctbl_popl_stat_cd not in ('VOIDD','BCKDT')
10606: and pel.per_in_ler_id = p_per_in_ler_id;

Line 12196: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

12192: --
12193: hr_utility.set_location ('DEFER UPDATED ' || l_defer_popl_id,9653);
12194: hr_utility.set_location ('DEFER OVN ' || l_defer_popl_ovn,9653);
12195: --
12196: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
12197: (p_validate => FALSE,
12198: p_pil_elctbl_chc_popl_id => l_defer_popl_id,
12199: p_object_version_number => l_defer_popl_ovn,
12200: p_effective_date => p_effective_date,

Line 12867: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

12863: if c_pil_elctbl_chc_popl%notfound then
12864: close c_pil_elctbl_chc_popl;
12865: exit;
12866: else
12867: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
12868: (p_pil_elctbl_chc_popl_id => l_pil_elctbl_chc_popl.pil_elctbl_chc_popl_id
12869: ,p_pil_elctbl_popl_stat_cd => 'PROCD'
12870: ,p_business_group_id => p_business_group_id
12871: ,p_object_version_number => l_pil_elctbl_chc_popl.object_version_number