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 2440: from ben_pil_elctbl_chc_popl

2436:
2437: --
2438: cursor c_pil_popl is
2439: select *
2440: from ben_pil_elctbl_chc_popl
2441: where per_in_ler_id = p_per_in_ler_id;
2442: --
2443: --bug#2718215
2444: cursor c_result_pgm (p_pgm_id number) is

Line 2524: update ben_pil_elctbl_chc_popl

2520: --
2521: if i.pgm_id = ben_manage_life_events.g_pil_popl_tbl(j).pgm_id or
2522: i.pl_id = ben_manage_life_events.g_pil_popl_tbl(j).pl_id then
2523: --
2524: update ben_pil_elctbl_chc_popl
2525: set elcns_made_dt = ben_manage_life_events.g_pil_popl_tbl(j).elcns_made_dt
2526: where pil_elctbl_chc_popl_id = i.pil_elctbl_chc_popl_id;
2527: --
2528: --

Line 2539: update ben_pil_elctbl_chc_popl

2535: if i.pgm_id is not null then
2536: open c_result_pgm (i.pgm_id);
2537: fetch c_result_pgm into l_effective_start_date;
2538: if c_result_pgm%found then
2539: update ben_pil_elctbl_chc_popl
2540: set elcns_made_dt = l_effective_start_date
2541: where pil_elctbl_chc_popl_id = i.pil_elctbl_chc_popl_id;
2542: end if;
2543: close c_result_pgm;

Line 2548: update ben_pil_elctbl_chc_popl

2544: elsif i.pl_id is not null then
2545: open c_result_pln (i.pl_id);
2546: fetch c_result_pln into l_effective_start_date;
2547: if c_result_pln%found then
2548: update ben_pil_elctbl_chc_popl
2549: set elcns_made_dt = l_effective_start_date
2550: where pil_elctbl_chc_popl_id = i.pil_elctbl_chc_popl_id;
2551: end if;
2552: close c_result_pln;

Line 2986: ben_pil_elctbl_chc_popl mgr_pel_0,

2982: p_lf_evt_ocrd_dt date,
2983: p_business_group_id number) is
2984: select unique pel_0.mgr_pil_elctbl_chc_popl_id
2985: from ben_cwb_hrchy pel_0,
2986: ben_pil_elctbl_chc_popl mgr_pel_0,
2987: ben_per_in_ler pil_0
2988: where
2989: mgr_pel_0.pil_elctbl_chc_popl_id = pel_0.mgr_pil_elctbl_chc_popl_id
2990: and mgr_pel_0.per_in_ler_id = pil_0.per_in_ler_id

Line 3000: ben_pil_elctbl_chc_popl mgr_pel,

2996: and pel_0.lvl_num > 0
2997: and pel_0.mgr_pil_elctbl_chc_popl_id not in
2998: ( select mgr_pel.pil_elctbl_chc_popl_id
2999: from ben_cwb_hrchy hrh,
3000: ben_pil_elctbl_chc_popl mgr_pel,
3001: ben_per_in_ler pil
3002: where hrh.mgr_pil_elctbl_chc_popl_id =
3003: hrh.emp_pil_elctbl_chc_popl_id
3004: and mgr_pel.pil_elctbl_chc_popl_id = hrh.mgr_pil_elctbl_chc_popl_id

Line 3024: ben_pil_elctbl_chc_popl pel ,

3020: cwb.emp_pil_elctbl_chc_popl_id,
3021: pel.ws_mgr_id
3022: from
3023: ben_cwb_hrchy cwb,
3024: ben_pil_elctbl_chc_popl pel ,
3025: ben_per_in_ler pil
3026: where
3027: cwb.mgr_pil_elctbl_chc_popl_id = -1
3028: and pel.pil_elctbl_chc_popl_id = cwb.emp_pil_elctbl_chc_popl_id

Line 3050: ben_pil_elctbl_chc_popl pel,

3046: pil.lf_evt_ocrd_dt,
3047: pil.ler_id,
3048: pil.business_group_id
3049: from
3050: ben_pil_elctbl_chc_popl pel,
3051: ben_per_in_ler pil
3052: where
3053: pel.per_in_ler_id = pil.per_in_ler_id
3054: and pel.pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id

Line 3074: from ben_pil_elctbl_chc_popl pel,

3070: p_ler_id number,
3071: p_business_group_id number) is
3072: select pel.ws_mgr_id,
3073: pel.pil_elctbl_chc_popl_id
3074: from ben_pil_elctbl_chc_popl pel,
3075: ben_per_in_ler pil
3076: where pel.per_in_ler_id = pil.per_in_ler_id
3077: and pel.pl_id = p_pl_id
3078: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 3150: from ben_pil_elctbl_chc_popl pel ,

3146: -- Bug 2541072 : Do not consider all per in ler's.
3147: --
3148: and exists
3149: (select null
3150: from ben_pil_elctbl_chc_popl pel ,
3151: ben_per_in_ler pil
3152: where pel.pil_elctbl_chc_popl_id = cwh.emp_pil_elctbl_chc_popl_id
3153: and pel.per_in_ler_id = pil.per_in_ler_id
3154: and pil.per_in_ler_stat_cd = 'STRTD'

Line 3185: from ben_pil_elctbl_chc_popl pel ,

3181: -- Bug 2541072 : Do not consider all per in ler's.
3182: --
3183: and exists
3184: (select null
3185: from ben_pil_elctbl_chc_popl pel ,
3186: ben_per_in_ler pil
3187: where pel.pil_elctbl_chc_popl_id = cwh.emp_pil_elctbl_chc_popl_id
3188: and pel.per_in_ler_id = pil.per_in_ler_id
3189: and pil.per_in_ler_stat_cd = 'STRTD'

Line 3357: from ben_pil_elctbl_chc_popl pel,

3353: --
3354: delete from ben_cwb_hrchy
3355: where emp_pil_elctbl_chc_popl_id in (
3356: select pel.pil_elctbl_chc_popl_id
3357: from ben_pil_elctbl_chc_popl pel,
3358: ben_per_in_ler pil
3359: where pel.pl_id = lv_pl_id
3360: and pil.lf_evt_ocrd_dt = lv_lf_evt_ocrd_dt
3361: and pil.per_in_ler_id = pel.per_in_ler_id

Line 3367: from ben_pil_elctbl_chc_popl pel,

3363: --
3364: delete from ben_cwb_hrchy
3365: where mgr_pil_elctbl_chc_popl_id in (
3366: select pel.pil_elctbl_chc_popl_id
3367: from ben_pil_elctbl_chc_popl pel,
3368: ben_per_in_ler pil
3369: where pel.pl_id = lv_pl_id
3370: and pil.lf_evt_ocrd_dt = lv_lf_evt_ocrd_dt
3371: and pil.per_in_ler_id = pel.per_in_ler_id

Line 3859: from ben_pil_elctbl_chc_popl pel,

3855: pel.acty_ref_perd_cd,
3856: pel.business_group_id per_business_group_id,
3857: per.business_group_id mgr_business_group_id,
3858: pel.ws_mgr_id
3859: from ben_pil_elctbl_chc_popl pel,
3860: per_all_people_f per
3861: where pel.per_in_ler_id = cv_per_in_ler_id
3862: and pel.ws_mgr_id = per.person_id (+)
3863: and l_effective_date between effective_start_date

Line 3880: ben_pil_elctbl_chc_popl pel,

3876: pel.acty_ref_perd_cd,
3877: epe.business_group_id per_business_group_id,
3878: per.business_group_id mgr_business_group_id
3879: from ben_elig_per_elctbl_chc epe,
3880: ben_pil_elctbl_chc_popl pel,
3881: per_all_people_f per
3882: where epe.per_in_ler_id = cv_per_in_ler_id
3883: and epe.per_in_ler_id = pel.per_in_ler_id
3884: and epe.pl_id = pel.pl_id

Line 4396: ben_pil_elctbl_chc_popl pel,

4392: pel.acty_ref_perd_cd,
4393: epe.business_group_id per_business_group_id,
4394: per.business_group_id mgr_business_group_id
4395: from ben_elig_per_elctbl_chc epe,
4396: ben_pil_elctbl_chc_popl pel,
4397: per_all_people_f per
4398: where epe.per_in_ler_id = cv_per_in_ler_id
4399: and epe.per_in_ler_id = pel.per_in_ler_id
4400: and epe.pl_id = pel.pl_id

Line 5013: from ben_pil_elctbl_chc_popl

5009:
5010: cursor c_popl is
5011: select pil_elctbl_chc_popl_id,
5012: object_version_number
5013: from ben_pil_elctbl_chc_popl
5014: where per_in_ler_id = l_pil_rec.per_in_ler_id;
5015: l_popl_rec c_popl%rowtype;
5016:
5017: l_package varchar2(80);

Line 5037: ben_Pil_Elctbl_chc_Popl_api.delete_Pil_Elctbl_chc_Popl

5033: if c_popl%notfound then
5034: exit;
5035: end if;
5036:
5037: ben_Pil_Elctbl_chc_Popl_api.delete_Pil_Elctbl_chc_Popl
5038: (p_pil_elctbl_chc_popl_id => l_popl_rec.pil_elctbl_chc_popl_id,
5039: p_object_version_number => l_popl_rec.object_version_number,
5040: p_effective_date => p_effective_date);
5041:

Line 7000: from ben_pil_elctbl_chc_popl pel

6996: l_package varchar2(80) := g_package||'.rebuild_heirarchy' ;
6997: -- Bug 2574791
6998: cursor c_pel is
6999: select pel.pl_id, pil.lf_evt_ocrd_dt, pel.business_group_id
7000: from ben_pil_elctbl_chc_popl pel
7001: ,ben_per_in_ler pil
7002: where pel.per_in_ler_id = pil.per_in_ler_id
7003: and pel.pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id;
7004: --

Line 9741: from ben_pil_elctbl_chc_popl popl

9737: --
9738: cursor c_pil_elctbl_chc_popl (p_per_in_ler_id in number) is
9739: select popl.pil_elctbl_chc_popl_id,
9740: popl.object_version_number
9741: from ben_pil_elctbl_chc_popl popl
9742: where per_in_ler_id = p_per_in_ler_id
9743: and not exists
9744: (select null
9745: from ben_elig_per_elctbl_chc epe

Line 9751: from ben_pil_elctbl_chc_popl popl

9747: and elctbl_flag = 'Y');
9748: --
9749: cursor c_pil (p_per_in_ler_id number, p_pgm_id number, p_pl_id number) is
9750: select 'Y'
9751: from ben_pil_elctbl_chc_popl popl
9752: where per_in_ler_id = p_per_in_ler_id
9753: and (popl.pgm_id = p_pgm_id or
9754: popl.pl_id = p_pl_id);
9755: --

Line 10116: from ben_pil_elctbl_chc_popl pel

10112: --
10113: -- Defer ENH.
10114: cursor c_pel_defer(p_pgm_id number,p_per_in_ler_id in number) is
10115: select pel.*
10116: from ben_pil_elctbl_chc_popl pel
10117: where pel.pgm_id = p_pgm_id
10118: and pel.pl_id is null
10119: and pel.pil_elctbl_popl_stat_cd not in ('VOIDD','BCKDT')
10120: and pel.per_in_ler_id = p_per_in_ler_id;

Line 10127: from ben_pil_elctbl_chc_popl pel

10123: --
10124: cursor c_pel_pnip_defer (p_pl_id number,p_per_in_ler_id in number) is
10125: --
10126: select pel.*
10127: from ben_pil_elctbl_chc_popl pel
10128: where pel.pl_id = p_pl_id
10129: and pel.pgm_id is null
10130: and pel.pil_elctbl_popl_stat_cd not in ('VOIDD','BCKDT')
10131: and pel.per_in_ler_id = p_per_in_ler_id;

Line 11656: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

11652: --
11653: hr_utility.set_location ('DEFER UPDATED ' || l_defer_popl_id,9653);
11654: hr_utility.set_location ('DEFER OVN ' || l_defer_popl_ovn,9653);
11655: --
11656: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
11657: (p_validate => FALSE,
11658: p_pil_elctbl_chc_popl_id => l_defer_popl_id,
11659: p_object_version_number => l_defer_popl_ovn,
11660: p_effective_date => p_effective_date,

Line 12249: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

12245: if c_pil_elctbl_chc_popl%notfound then
12246: close c_pil_elctbl_chc_popl;
12247: exit;
12248: else
12249: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
12250: (p_pil_elctbl_chc_popl_id => l_pil_elctbl_chc_popl.pil_elctbl_chc_popl_id
12251: ,p_pil_elctbl_popl_stat_cd => 'PROCD'
12252: ,p_business_group_id => p_business_group_id
12253: ,p_object_version_number => l_pil_elctbl_chc_popl.object_version_number