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 2818: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc

2814: cursor c_enrt_rt is
2815: select *
2816: from ben_enrt_rt
2817: where elig_per_elctbl_chc_id in
2818: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
2819: where per_in_ler_id = p_per_in_ler_id)
2820: union
2821: select *
2822: from ben_enrt_rt

Line 2826: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc

2822: from ben_enrt_rt
2823: where enrt_bnft_id in
2824: (select enrt_bnft_id from ben_enrt_bnft
2825: where elig_per_elctbl_chc_id in
2826: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
2827: where per_in_ler_id = p_per_in_ler_id));
2828:
2829: --
2830: cursor c_pil_popl is

Line 2967: from ben_elig_per_elctbl_chc epe

2963: --cursors
2964: cursor c_epe is
2965: select elig_per_elctbl_chc_id,
2966: object_version_number
2967: from ben_elig_per_elctbl_chc epe
2968: where elig_per_elctbl_chc_id = l_elig_per_elctbl_chc_id
2969: and per_in_ler_id = p_per_in_ler_id ;
2970: --
2971: l_epe c_epe%ROWTYPE;

Line 3039: ben_elig_per_elctbl_chc epe

3035: cursor c_epe is
3036: select
3037: elig_per_elctbl_chc_id
3038: from
3039: ben_elig_per_elctbl_chc epe
3040: where
3041: per_in_ler_id = p_per_in_ler_id and
3042: in_pndg_wkflow_flag = 'S';
3043: --

Line 3047: update ben_elig_per_elctbl_chc

3043: --
3044: begin
3045: --
3046: /*
3047: update ben_elig_per_elctbl_chc
3048: set in_pndg_wkflow_flag = 'N'
3049: where in_pndg_wkflow_flag = 'S'
3050: and per_in_ler_id = p_per_in_ler_id;
3051: */

Line 3826: ben_elig_per_elctbl_chc mgr_epe_0,

3822: p_lf_evt_ocrd_dt date,
3823: p_business_group_id number) is
3824: select unique epe_0.mgr_elig_per_elctbl_chc_id
3825: from ben_cwb_mgr_hrchy epe_0,
3826: ben_elig_per_elctbl_chc mgr_epe_0,
3827: ben_per_in_ler pil_0
3828: where
3829: mgr_epe_0.elig_per_elctbl_chc_id = epe_0.mgr_elig_per_elctbl_chc_id
3830: and mgr_epe_0.per_in_ler_id = pil_0.per_in_ler_id

Line 3840: ben_elig_per_elctbl_chc mgr_epe,

3836: and epe_0.lvl_num > 0
3837: and epe_0.mgr_elig_per_elctbl_chc_id not in
3838: ( select mgr_epe.elig_per_elctbl_chc_id
3839: from ben_cwb_mgr_hrchy hrh,
3840: ben_elig_per_elctbl_chc mgr_epe,
3841: ben_per_in_ler pil
3842: where hrh.mgr_elig_per_elctbl_chc_id =
3843: hrh.emp_elig_per_elctbl_chc_id
3844: and mgr_epe.elig_per_elctbl_chc_id = hrh.mgr_elig_per_elctbl_chc_id

Line 3864: ben_elig_per_elctbl_chc epe ,

3860: cwb.emp_elig_per_elctbl_chc_id,
3861: epe.ws_mgr_id
3862: from
3863: ben_cwb_mgr_hrchy cwb,
3864: ben_elig_per_elctbl_chc epe ,
3865: ben_per_in_ler pil
3866: where
3867: cwb.mgr_elig_per_elctbl_chc_id = -1
3868: and epe.elig_per_elctbl_chc_id = cwb.emp_elig_per_elctbl_chc_id

Line 3890: ben_elig_per_elctbl_chc epe,

3886: pil.lf_evt_ocrd_dt,
3887: pil.ler_id,
3888: pil.business_group_id
3889: from
3890: ben_elig_per_elctbl_chc epe,
3891: ben_per_in_ler pil
3892: where
3893: epe.per_in_ler_id = pil.per_in_ler_id
3894: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id

Line 3914: from ben_elig_per_elctbl_chc epe,

3910: p_ler_id number,
3911: p_business_group_id number) is
3912: select epe.ws_mgr_id,
3913: epe.elig_per_elctbl_chc_id
3914: from ben_elig_per_elctbl_chc epe,
3915: ben_per_in_ler pil
3916: where epe.per_in_ler_id = pil.per_in_ler_id
3917: and epe.pl_id = p_pl_id
3918: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 3999: from ben_elig_per_elctbl_chc epe ,

3995: -- Bug 2541072 : Do not consider all per in ler's.
3996: --
3997: and exists
3998: (select null
3999: from ben_elig_per_elctbl_chc epe ,
4000: ben_per_in_ler pil
4001: where epe.elig_per_elctbl_chc_id = cwh.emp_elig_per_elctbl_chc_id
4002: and epe.per_in_ler_id = pil.per_in_ler_id
4003: and pil.per_in_ler_stat_cd = 'STRTD'

Line 4020: from ben_elig_per_elctbl_chc epe ,

4016: -- Bug 2541072 : Do not consider all per in ler's.
4017: --
4018: and exists
4019: (select null
4020: from ben_elig_per_elctbl_chc epe ,
4021: ben_per_in_ler pil
4022: where epe.elig_per_elctbl_chc_id = cwh.emp_elig_per_elctbl_chc_id
4023: and epe.per_in_ler_id = pil.per_in_ler_id
4024: and pil.per_in_ler_stat_cd = 'STRTD'

Line 4226: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;

4222: l_mgr_person_id_temp number;
4223: l_assignment_id number;
4224: l_elig_per_elctbl_chc_id number;
4225: --
4226: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4227: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4228: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4229: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4230: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;

Line 4227: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;

4223: l_assignment_id number;
4224: l_elig_per_elctbl_chc_id number;
4225: --
4226: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4227: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4228: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4229: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4230: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
4231: -- CWBITEM

Line 4228: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;

4224: l_elig_per_elctbl_chc_id number;
4225: --
4226: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4227: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4228: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4229: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4230: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
4231: -- CWBITEM
4232: l_emp_pel_id number;

Line 4229: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;

4225: --
4226: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4227: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4228: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4229: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4230: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
4231: -- CWBITEM
4232: l_emp_pel_id number;
4233: l_pel_id number;

Line 4230: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;

4226: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4227: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4228: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4229: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4230: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
4231: -- CWBITEM
4232: l_emp_pel_id number;
4233: l_pel_id number;
4234: --

Line 4271: from ben_elig_per_elctbl_chc epe,

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

Line 4325: from ben_elig_per_elctbl_chc epe,

4321: --
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: --

Line 4768: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;

4764: l_mgr_person_id_temp number;
4765: l_assignment_id number;
4766: l_elig_per_elctbl_chc_id number;
4767: --
4768: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4769: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4770: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4771: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4772: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;

Line 4769: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;

4765: l_assignment_id number;
4766: l_elig_per_elctbl_chc_id number;
4767: --
4768: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4769: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4770: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4771: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4772: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
4773: --

Line 4770: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;

4766: l_elig_per_elctbl_chc_id number;
4767: --
4768: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4769: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4770: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4771: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4772: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
4773: --
4774: cursor c_epe(cv_per_in_ler_id in number) is

Line 4771: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;

4767: --
4768: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4769: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4770: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4771: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4772: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
4773: --
4774: cursor c_epe(cv_per_in_ler_id in number) is
4775: select epe.* ,

Line 4772: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;

4768: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
4769: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
4770: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
4771: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
4772: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
4773: --
4774: cursor c_epe(cv_per_in_ler_id in number) is
4775: select epe.* ,
4776: pel.dflt_enrt_dt,

Line 4787: from ben_elig_per_elctbl_chc epe,

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

Line 5294: from ben_elig_per_elctbl_chc epe1

5290: cursor c_epe1 is
5291: select epe1.elig_per_elctbl_chc_id,
5292: epe1.object_version_number,
5293: epe1.pl_id
5294: from ben_elig_per_elctbl_chc epe1
5295: where epe1.per_in_ler_id = p_per_in_ler_id
5296: and epe1.pl_id is not null
5297: and epe1.oipl_id is null;
5298:

Line 5301: from ben_elig_per_elctbl_chc epe2

5297: and epe1.oipl_id is null;
5298:
5299: cursor c_epe2 is
5300: select 'x'
5301: from ben_elig_per_elctbl_chc epe2
5302: where epe2.per_in_ler_id = p_per_in_ler_id
5303: and epe2.oipl_id is not null
5304: and epe2.pl_id = l_pl_id
5305: and epe2.elig_flag ='Y';

Line 5398: from ben_elig_per_elctbl_chc epe

5394: and pil.person_id = p_person_id
5395: and ptnl.ptnl_ler_for_per_id = pil.ptnl_ler_for_per_id
5396: and not exists
5397: (select 'x'
5398: from ben_elig_per_elctbl_chc epe
5399: where epe.per_in_ler_id = pil.per_in_ler_id);
5400: l_pil_rec c_pil%rowtype;
5401:
5402: cursor c_popl is

Line 10153: from ben_elig_per_elctbl_chc epe

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

Line 10266: type epetab is table of ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%type;

10262:
10263:
10264: -- bug 12354919
10265:
10266: type epetab is table of ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%type;
10267: t_epe_tbl epetab;
10268:
10269: l_cnt number;
10270:

Line 10273: from ben_elig_per_elctbl_chc epe

10269: l_cnt number;
10270:
10271: cursor c_epe(p_per_in_ler_id number) is
10272: select epe.elig_per_elctbl_chc_id
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

Line 10281: from ben_elig_per_elctbl_chc epe2

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
10282: where pel.pil_elctbl_chc_popl_id=epe2.pil_elctbl_chc_popl_id
10283: and nvl(epe2.in_pndg_wkflow_flag,'N') in ('Y', 'S')));
10284:
10285: