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_CWB_HRCHY

Line 3377: from ben_cwb_hrchy pel_0,

3373: cursor c_no_0_hrchy(p_pl_id number,
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

Line 3391: from ben_cwb_hrchy hrh,

3387: and pil_0.per_in_ler_stat_cd = 'STRTD'
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

Line 3415: ben_cwb_hrchy cwb,

3411: select
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

Line 3512: insert into ben_cwb_hrchy (

3508: ||p_emp_pil_elctbl_chc_popl_id,10);
3509: hr_utility.set_location('insert_mgr_hrchy p_mgr_pil_elctbl_chc_popl_id '
3510: ||p_mgr_pil_elctbl_chc_popl_id || ' lvl = ' || p_lvl_num, 20);
3511: end if;
3512: insert into ben_cwb_hrchy (
3513: emp_pil_elctbl_chc_popl_id,
3514: mgr_pil_elctbl_chc_popl_id,
3515: lvl_num )
3516: values (

Line 3534: from ben_cwb_hrchy cwh

3530: -- CWB bug : 2712602
3531: --
3532: cursor c_cwh is
3533: select rowid
3534: from ben_cwb_hrchy cwh
3535: where cwh.lvl_num = -1 and
3536: cwh.mgr_pil_elctbl_chc_popl_id = -1
3537: --
3538: -- Bug 2541072 : Do not consider all per in ler's.

Line 3561: from ben_cwb_hrchy cwh

3557: -- And also the last subordinate is now reporting to another manager
3558: -- we need to delete the pel,0,0 row of the employee.
3559: --
3560: delete
3561: from ben_cwb_hrchy cwh
3562: where (( cwh.lvl_num = -1
3563: and cwh.mgr_pil_elctbl_chc_popl_id = -1) OR
3564: ( cwh.lvl_num = 0 and
3565: cwh.mgr_pil_elctbl_chc_popl_id = cwh.emp_pil_elctbl_chc_popl_id ) )

Line 3568: from ben_cwb_hrchy cwh1

3564: ( cwh.lvl_num = 0 and
3565: cwh.mgr_pil_elctbl_chc_popl_id = cwh.emp_pil_elctbl_chc_popl_id ) )
3566: and not exists
3567: (select null
3568: from ben_cwb_hrchy cwh1
3569: where cwh1.mgr_pil_elctbl_chc_popl_id = cwh.emp_pil_elctbl_chc_popl_id
3570: and cwh1.lvl_num <> 0
3571: )
3572: --

Line 3594: update ben_cwb_hrchy cwh

3590: for l_cwh in c_cwh loop
3591: --
3592: begin
3593: --
3594: update ben_cwb_hrchy cwh
3595: set cwh.mgr_pil_elctbl_chc_popl_id = cwh.emp_pil_elctbl_chc_popl_id,
3596: cwh.lvl_num = 0
3597: where cwh.lvl_num = -1
3598: and cwh.mgr_pil_elctbl_chc_popl_id = -1

Line 3602: delete from ben_cwb_hrchy where rowid = l_cwh.rowid;null;

3598: and cwh.mgr_pil_elctbl_chc_popl_id = -1
3599: and cwh.rowid = l_cwh.rowid;
3600: exception
3601: when others then
3602: delete from ben_cwb_hrchy where rowid = l_cwh.rowid;null;
3603: end;
3604: --
3605: end loop;
3606: --

Line 3746: delete from ben_cwb_hrchy

3742: end if;
3743: --
3744: -- CWB 2712602 : Delete all the hrchy data linked to backed out per in ler.
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

Line 3756: delete from ben_cwb_hrchy

3752: and pil.lf_evt_ocrd_dt = lv_lf_evt_ocrd_dt
3753: and pil.per_in_ler_id = pel.per_in_ler_id
3754: and pil.per_in_ler_stat_cd = 'BCKDT');
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

Line 3776: insert into ben_cwb_hrchy (

3772: for l_no_0_hrchy in c_no_0_hrchy(lv_pl_id, lv_lf_evt_ocrd_dt, lv_business_group_id) loop
3773: --
3774: begin
3775: --
3776: insert into ben_cwb_hrchy (
3777: emp_pil_elctbl_chc_popl_id,
3778: mgr_pil_elctbl_chc_popl_id,
3779: lvl_num )
3780: values (

Line 4326: ben_cwb_hrchy hrc

4322: cursor c_hrchy(cv_emp_epe_id in number) is
4323: select hrc.emp_pil_elctbl_chc_popl_id,
4324: epe.pil_elctbl_chc_popl_id
4325: from ben_elig_per_elctbl_chc epe,
4326: ben_cwb_hrchy hrc
4327: where epe.elig_per_elctbl_chc_id = cv_emp_epe_id
4328: and hrc.emp_pil_elctbl_chc_popl_id(+) = epe.pil_elctbl_chc_popl_id;
4329: --
4330: begin

Line 4511: insert into ben_cwb_hrchy (

4507: --
4508: if l_pel_id is not null and l_emp_pel_id is null then
4509: --
4510: begin
4511: insert into ben_cwb_hrchy (
4512: emp_pil_elctbl_chc_popl_id,
4513: mgr_pil_elctbl_chc_popl_id,
4514: lvl_num )
4515: values(

Line 7442: insert into ben_cwb_hrchy (

7438: --
7439: -- Step 1
7440: begin
7441: --
7442: insert into ben_cwb_hrchy (
7443: emp_pil_elctbl_chc_popl_id,
7444: mgr_pil_elctbl_chc_popl_id,
7445: lvl_num )
7446: values (

Line 7475: from ben_cwb_hrchy

7471: declare
7472: cursor c_emp_repo is
7473: select
7474: emp_pil_elctbl_chc_popl_id
7475: from ben_cwb_hrchy
7476: where mgr_pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id
7477: and lvl_num > 0;
7478: begin
7479: --

Line 7484: insert into ben_cwb_hrchy (

7480: for r_emp_repo in c_emp_repo loop
7481: --
7482: begin
7483: -- Bug 2574791
7484: insert into ben_cwb_hrchy (
7485: emp_pil_elctbl_chc_popl_id,
7486: mgr_pil_elctbl_chc_popl_id,
7487: lvl_num ) values (r_emp_repo.emp_pil_elctbl_chc_popl_id, -1, -1);
7488: exception when others then

Line 7513: delete from ben_cwb_hrchy

7509: begin
7510: --
7511: --First Delete the Managers in the Hierarchy
7512: --
7513: delete from ben_cwb_hrchy
7514: where emp_pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id
7515: and lvl_num >= 0;
7516: --
7517: -- Now delete the Employees reporting to this manager(if he is a manager).

Line 7519: delete from ben_cwb_hrchy

7515: and lvl_num >= 0;
7516: --
7517: -- Now delete the Employees reporting to this manager(if he is a manager).
7518: --
7519: delete from ben_cwb_hrchy
7520: where emp_pil_elctbl_chc_popl_id in (
7521: select emp_pil_elctbl_chc_popl_id
7522: from ben_cwb_hrchy
7523: where mgr_pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id )

Line 7522: from ben_cwb_hrchy

7518: --
7519: delete from ben_cwb_hrchy
7520: where emp_pil_elctbl_chc_popl_id in (
7521: select emp_pil_elctbl_chc_popl_id
7522: from ben_cwb_hrchy
7523: where mgr_pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id )
7524: and lvl_num >= 0;
7525: --
7526: exception when others then

Line 7553: insert into ben_cwb_hrchy(

7549: end if;
7550: --
7551: begin
7552: --
7553: insert into ben_cwb_hrchy(
7554: emp_pil_elctbl_chc_popl_id,
7555: mgr_pil_elctbl_chc_popl_id,
7556: lvl_num )
7557: select

Line 7561: from ben_cwb_hrchy cwb1

7557: select
7558: distinct emp_pil_elctbl_chc_popl_id,
7559: emp_pil_elctbl_chc_popl_id,
7560: 0
7561: from ben_cwb_hrchy cwb1
7562: where emp_pil_elctbl_chc_popl_id =
7563: ( select mgr_pil_elctbl_chc_popl_id from ben_cwb_hrchy
7564: where emp_pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id
7565: and lvl_num = 1 )

Line 7563: ( select mgr_pil_elctbl_chc_popl_id from ben_cwb_hrchy

7559: emp_pil_elctbl_chc_popl_id,
7560: 0
7561: from ben_cwb_hrchy cwb1
7562: where emp_pil_elctbl_chc_popl_id =
7563: ( select mgr_pil_elctbl_chc_popl_id from ben_cwb_hrchy
7564: where emp_pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id
7565: and lvl_num = 1 )
7566: and not exists ( select null from ben_cwb_hrchy cwb2
7567: where cwb1.emp_pil_elctbl_chc_popl_id = cwb2.emp_pil_elctbl_chc_popl_id

Line 7566: and not exists ( select null from ben_cwb_hrchy cwb2

7562: where emp_pil_elctbl_chc_popl_id =
7563: ( select mgr_pil_elctbl_chc_popl_id from ben_cwb_hrchy
7564: where emp_pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id
7565: and lvl_num = 1 )
7566: and not exists ( select null from ben_cwb_hrchy cwb2
7567: where cwb1.emp_pil_elctbl_chc_popl_id = cwb2.emp_pil_elctbl_chc_popl_id
7568: and lvl_num = 0 ) ;
7569: --
7570: exception when no_data_found then