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_ELIG_PER_ELCTBL_CHC

Line 2426: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc

2422: cursor c_enrt_rt is
2423: select *
2424: from ben_enrt_rt
2425: where elig_per_elctbl_chc_id in
2426: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
2427: where per_in_ler_id = p_per_in_ler_id)
2428: union
2429: select *
2430: from ben_enrt_rt

Line 2434: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc

2430: from ben_enrt_rt
2431: where enrt_bnft_id in
2432: (select enrt_bnft_id from ben_enrt_bnft
2433: where elig_per_elctbl_chc_id in
2434: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
2435: where per_in_ler_id = p_per_in_ler_id));
2436:
2437: --
2438: cursor c_pil_popl is

Line 2575: from ben_elig_per_elctbl_chc epe

2571: --cursors
2572: cursor c_epe is
2573: select elig_per_elctbl_chc_id,
2574: object_version_number
2575: from ben_elig_per_elctbl_chc epe
2576: where elig_per_elctbl_chc_id = l_elig_per_elctbl_chc_id
2577: and per_in_ler_id = p_per_in_ler_id ;
2578: --
2579: l_epe c_epe%ROWTYPE;

Line 2647: ben_elig_per_elctbl_chc epe

2643: cursor c_epe is
2644: select
2645: elig_per_elctbl_chc_id
2646: from
2647: ben_elig_per_elctbl_chc epe
2648: where
2649: per_in_ler_id = p_per_in_ler_id and
2650: in_pndg_wkflow_flag = 'S';
2651: --

Line 2655: update ben_elig_per_elctbl_chc

2651: --
2652: begin
2653: --
2654: /*
2655: update ben_elig_per_elctbl_chc
2656: set in_pndg_wkflow_flag = 'N'
2657: where in_pndg_wkflow_flag = 'S'
2658: and per_in_ler_id = p_per_in_ler_id;
2659: */

Line 3434: ben_elig_per_elctbl_chc mgr_epe_0,

3430: p_lf_evt_ocrd_dt date,
3431: p_business_group_id number) is
3432: select unique epe_0.mgr_elig_per_elctbl_chc_id
3433: from ben_cwb_mgr_hrchy epe_0,
3434: ben_elig_per_elctbl_chc mgr_epe_0,
3435: ben_per_in_ler pil_0
3436: where
3437: mgr_epe_0.elig_per_elctbl_chc_id = epe_0.mgr_elig_per_elctbl_chc_id
3438: and mgr_epe_0.per_in_ler_id = pil_0.per_in_ler_id

Line 3448: ben_elig_per_elctbl_chc mgr_epe,

3444: and epe_0.lvl_num > 0
3445: and epe_0.mgr_elig_per_elctbl_chc_id not in
3446: ( select mgr_epe.elig_per_elctbl_chc_id
3447: from ben_cwb_mgr_hrchy hrh,
3448: ben_elig_per_elctbl_chc mgr_epe,
3449: ben_per_in_ler pil
3450: where hrh.mgr_elig_per_elctbl_chc_id =
3451: hrh.emp_elig_per_elctbl_chc_id
3452: and mgr_epe.elig_per_elctbl_chc_id = hrh.mgr_elig_per_elctbl_chc_id

Line 3472: ben_elig_per_elctbl_chc epe ,

3468: cwb.emp_elig_per_elctbl_chc_id,
3469: epe.ws_mgr_id
3470: from
3471: ben_cwb_mgr_hrchy cwb,
3472: ben_elig_per_elctbl_chc epe ,
3473: ben_per_in_ler pil
3474: where
3475: cwb.mgr_elig_per_elctbl_chc_id = -1
3476: and epe.elig_per_elctbl_chc_id = cwb.emp_elig_per_elctbl_chc_id

Line 3498: ben_elig_per_elctbl_chc epe,

3494: pil.lf_evt_ocrd_dt,
3495: pil.ler_id,
3496: pil.business_group_id
3497: from
3498: ben_elig_per_elctbl_chc epe,
3499: ben_per_in_ler pil
3500: where
3501: epe.per_in_ler_id = pil.per_in_ler_id
3502: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id

Line 3522: from ben_elig_per_elctbl_chc epe,

3518: p_ler_id number,
3519: p_business_group_id number) is
3520: select epe.ws_mgr_id,
3521: epe.elig_per_elctbl_chc_id
3522: from ben_elig_per_elctbl_chc epe,
3523: ben_per_in_ler pil
3524: where epe.per_in_ler_id = pil.per_in_ler_id
3525: and epe.pl_id = p_pl_id
3526: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 3607: from ben_elig_per_elctbl_chc epe ,

3603: -- Bug 2541072 : Do not consider all per in ler's.
3604: --
3605: and exists
3606: (select null
3607: from ben_elig_per_elctbl_chc epe ,
3608: ben_per_in_ler pil
3609: where epe.elig_per_elctbl_chc_id = cwh.emp_elig_per_elctbl_chc_id
3610: and epe.per_in_ler_id = pil.per_in_ler_id
3611: and pil.per_in_ler_stat_cd = 'STRTD'

Line 3628: from ben_elig_per_elctbl_chc epe ,

3624: -- Bug 2541072 : Do not consider all per in ler's.
3625: --
3626: and exists
3627: (select null
3628: from ben_elig_per_elctbl_chc epe ,
3629: ben_per_in_ler pil
3630: where epe.elig_per_elctbl_chc_id = cwh.emp_elig_per_elctbl_chc_id
3631: and epe.per_in_ler_id = pil.per_in_ler_id
3632: and pil.per_in_ler_stat_cd = 'STRTD'

Line 3834: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;

3830: l_mgr_person_id_temp number;
3831: l_assignment_id number;
3832: l_elig_per_elctbl_chc_id number;
3833: --
3834: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
3835: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
3836: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
3837: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
3838: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;

Line 3835: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;

3831: l_assignment_id number;
3832: l_elig_per_elctbl_chc_id number;
3833: --
3834: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
3835: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
3836: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
3837: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
3838: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
3839: -- CWBITEM

Line 3836: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;

3832: l_elig_per_elctbl_chc_id number;
3833: --
3834: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
3835: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
3836: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
3837: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
3838: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
3839: -- CWBITEM
3840: l_emp_pel_id number;

Line 3837: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;

3833: --
3834: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
3835: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
3836: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
3837: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
3838: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
3839: -- CWBITEM
3840: l_emp_pel_id number;
3841: l_pel_id number;

Line 3838: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;

3834: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
3835: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
3836: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
3837: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
3838: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
3839: -- CWBITEM
3840: l_emp_pel_id number;
3841: l_pel_id number;
3842: --

Line 3879: from ben_elig_per_elctbl_chc epe,

3875: pel.uom,
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

Line 3933: from ben_elig_per_elctbl_chc epe,

3929: --
3930: cursor c_hrchy(cv_emp_epe_id in number) is
3931: select hrc.emp_pil_elctbl_chc_popl_id,
3932: epe.pil_elctbl_chc_popl_id
3933: from ben_elig_per_elctbl_chc epe,
3934: ben_cwb_hrchy hrc
3935: where epe.elig_per_elctbl_chc_id = cv_emp_epe_id
3936: and hrc.emp_pil_elctbl_chc_popl_id(+) = epe.pil_elctbl_chc_popl_id;
3937: --

Line 4376: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;

4372: l_mgr_person_id_temp number;
4373: l_assignment_id number;
4374: l_elig_per_elctbl_chc_id number;
4375: --
4376: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4377: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4378: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4379: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4380: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;

Line 4377: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;

4373: l_assignment_id number;
4374: l_elig_per_elctbl_chc_id number;
4375: --
4376: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4377: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4378: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4379: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4380: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
4381: --

Line 4378: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;

4374: l_elig_per_elctbl_chc_id number;
4375: --
4376: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4377: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4378: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4379: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4380: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
4381: --
4382: cursor c_epe(cv_per_in_ler_id in number) is

Line 4379: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;

4375: --
4376: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4377: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4378: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4379: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4380: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
4381: --
4382: cursor c_epe(cv_per_in_ler_id in number) is
4383: select epe.* ,

Line 4380: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;

4376: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4377: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4378: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4379: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4380: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
4381: --
4382: cursor c_epe(cv_per_in_ler_id in number) is
4383: select epe.* ,
4384: pel.dflt_enrt_dt,

Line 4395: from ben_elig_per_elctbl_chc epe,

4391: pel.uom,
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

Line 4902: from ben_elig_per_elctbl_chc epe1

4898: cursor c_epe1 is
4899: select epe1.elig_per_elctbl_chc_id,
4900: epe1.object_version_number,
4901: epe1.pl_id
4902: from ben_elig_per_elctbl_chc epe1
4903: where epe1.per_in_ler_id = p_per_in_ler_id
4904: and epe1.pl_id is not null
4905: and epe1.oipl_id is null;
4906:

Line 4909: from ben_elig_per_elctbl_chc epe2

4905: and epe1.oipl_id is null;
4906:
4907: cursor c_epe2 is
4908: select 'x'
4909: from ben_elig_per_elctbl_chc epe2
4910: where epe2.per_in_ler_id = p_per_in_ler_id
4911: and epe2.oipl_id is not null
4912: and epe2.pl_id = l_pl_id
4913: and epe2.elig_flag ='Y';

Line 5006: from ben_elig_per_elctbl_chc epe

5002: and pil.person_id = p_person_id
5003: and ptnl.ptnl_ler_for_per_id = pil.ptnl_ler_for_per_id
5004: and not exists
5005: (select 'x'
5006: from ben_elig_per_elctbl_chc epe
5007: where epe.per_in_ler_id = pil.per_in_ler_id);
5008: l_pil_rec c_pil%rowtype;
5009:
5010: cursor c_popl is

Line 9745: from ben_elig_per_elctbl_chc epe

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
9746: where epe.pil_elctbl_chc_popl_id = popl.pil_elctbl_chc_popl_id
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