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_ELIG_PER_ELC_CHC_API dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 50: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;

46: -- Declare cursors and local variables
47: --
48: l_proc varchar2(72) ;
49: --
50: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
51: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
52: l_cbr_elig_perd_strt_dt ben_pil_elctbl_chc_popl.cbr_elig_perd_strt_dt%TYPE;
53: l_cbr_elig_perd_end_dt ben_pil_elctbl_chc_popl.cbr_elig_perd_end_dt%TYPE;
54: l_pel_pl_id number;

Line 51: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;

47: --
48: l_proc varchar2(72) ;
49: --
50: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
51: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
52: l_cbr_elig_perd_strt_dt ben_pil_elctbl_chc_popl.cbr_elig_perd_strt_dt%TYPE;
53: l_cbr_elig_perd_end_dt ben_pil_elctbl_chc_popl.cbr_elig_perd_end_dt%TYPE;
54: l_pel_pl_id number;
55: l_pel_pgm_id number;

Line 707: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;

703: is
704: --
705: l_proc varchar2(72) ;
706: --
707: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
708: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
709: l_pil_elctbl_chc_popl_id number;
710: l_oiplip_id number;
711: --

Line 708: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;

704: --
705: l_proc varchar2(72) ;
706: --
707: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
708: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
709: l_pil_elctbl_chc_popl_id number;
710: l_oiplip_id number;
711: --
712: begin

Line 1269: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;

1265: l_proc varchar2(72) ;
1266: --
1267: -- Declare cursors and local variables
1268: --
1269: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
1270: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
1271: l_pil_elctbl_chc_popl_id number;
1272: l_oiplip_id number;
1273: --

Line 1270: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;

1266: --
1267: -- Declare cursors and local variables
1268: --
1269: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
1270: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
1271: l_pil_elctbl_chc_popl_id number;
1272: l_oiplip_id number;
1273: --
1274: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;

Line 1274: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;

1270: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
1271: l_pil_elctbl_chc_popl_id number;
1272: l_oiplip_id number;
1273: --
1274: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
1275: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
1276: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
1277: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
1278: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;

Line 1275: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;

1271: l_pil_elctbl_chc_popl_id number;
1272: l_oiplip_id number;
1273: --
1274: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
1275: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
1276: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
1277: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
1278: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
1279: l_elig_flag varchar2(30);

Line 1276: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;

1272: l_oiplip_id number;
1273: --
1274: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
1275: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
1276: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
1277: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
1278: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
1279: l_elig_flag varchar2(30);
1280: l_inelig_rsn_cd varchar2(30);

Line 1277: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;

1273: --
1274: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
1275: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
1276: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
1277: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
1278: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
1279: l_elig_flag varchar2(30);
1280: l_inelig_rsn_cd varchar2(30);
1281: --

Line 1278: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;

1274: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
1275: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
1276: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
1277: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
1278: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
1279: l_elig_flag varchar2(30);
1280: l_inelig_rsn_cd varchar2(30);
1281: --
1282: l_sysdate date;

Line 1357: insert into ben_elig_per_elctbl_chc

1353: --
1354: if g_debug then
1355: hr_utility.set_location('Insert EPE: '||l_proc, 5);
1356: end if;
1357: insert into ben_elig_per_elctbl_chc
1358: ( elig_per_elctbl_chc_id,
1359: -- enrt_typ_cycl_cd,
1360: enrt_cvg_strt_dt_cd,
1361: -- enrt_perd_end_dt,

Line 1461: (ben_elig_per_elctbl_chc_s.nextval,

1457: program_update_date,
1458: object_version_number
1459: )
1460: Values
1461: (ben_elig_per_elctbl_chc_s.nextval,
1462: -- p_enrt_typ_cycl_cd,
1463: p_enrt_cvg_strt_dt_cd,
1464: -- p_enrt_perd_end_dt,
1465: -- p_enrt_perd_strt_dt,

Line 1773: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;

1769: --
1770: -- Declare cursors and local variables
1771: --
1772: l_proc varchar2(72) ;
1773: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
1774: --
1775: begin
1776: --
1777: g_debug := hr_utility.debug_enabled;

Line 2183: ben_elig_per_elctbl_chc epe1,

2179: cursor c1 is
2180: select per1.full_name person1,
2181: per2.full_name person2
2182: from ben_cwb_mgr_hrchy cwb1,
2183: ben_elig_per_elctbl_chc epe1,
2184: ben_per_in_ler pil1,
2185: per_all_people_f per1,
2186: per_all_people_f per2
2187: where cwb1.mgr_elig_per_elctbl_chc_id = p_emp_epe_id

Line 2199: from ben_elig_per_elctbl_chc epe2,

2195: and trunc(sysdate) between per2.effective_start_date
2196: and per2.effective_end_date
2197: and exists
2198: ( select 'x'
2199: from ben_elig_per_elctbl_chc epe2,
2200: ben_per_in_ler pil2
2201: where pil2.person_id = p_new_mgr_id
2202: and pil2.lf_evt_ocrd_dt = pil1.lf_evt_ocrd_dt
2203: and pil2.ler_id = pil1.ler_id

Line 2346: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;

2342: -- Declare cursors and local variables
2343: --
2344: l_proc varchar2(72) ;
2345: l_rec ben_epe_shd.g_rec_type;
2346: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
2347: l_elig_flag varchar2(30);
2348: l_inelig_rsn_cd varchar2(30);
2349: --
2350: begin

Line 2517: -- Update the ben_elig_per_elctbl_chc Row

2513: hr_utility.set_location(' EPE Upd'|| l_proc, 10);
2514: end if;
2515: ben_epe_shd.g_api_dml := true; -- Set the api dml status
2516: --
2517: -- Update the ben_elig_per_elctbl_chc Row
2518: --
2519:
2520: update ben_elig_per_elctbl_chc
2521: set

Line 2520: update ben_elig_per_elctbl_chc

2516: --
2517: -- Update the ben_elig_per_elctbl_chc Row
2518: --
2519:
2520: update ben_elig_per_elctbl_chc
2521: set
2522: elig_per_elctbl_chc_id = l_rec.elig_per_elctbl_chc_id,
2523: -- enrt_typ_cycl_cd = l_rec.enrt_typ_cycl_cd,
2524: enrt_cvg_strt_dt_cd = l_rec.enrt_cvg_strt_dt_cd,

Line 2712: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;

2708: --
2709: -- Declare cursors and local variables
2710: --
2711: l_proc varchar2(72) ;
2712: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
2713:
2714: cursor c_ctfn is
2715: /* select ecc.elctbl_chc_ctfn_id,
2716: ecc.object_version_number

Line 2720: from ben_elig_per_elctbl_chc

2716: ecc.object_version_number
2717: from ben_elctbl_chc_ctfn ecc
2718: where elig_per_elctbl_chc_id in
2719: (select elig_per_elctbl_chc_id
2720: from ben_elig_per_elctbl_chc
2721: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2722: or enrt_bnft_id in
2723: (select enrt_bnft_id
2724: from ben_enrt_bnft

Line 2732: from ben_elig_per_elctbl_chc

2728: ecc.object_version_number
2729: from ben_elctbl_chc_ctfn ecc
2730: where elig_per_elctbl_chc_id in
2731: (select elig_per_elctbl_chc_id
2732: from ben_elig_per_elctbl_chc
2733: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2734: UNION
2735: select ecc.elctbl_chc_ctfn_id,
2736: ecc.object_version_number

Line 2750: from ben_elig_per_elctbl_chc

2746: ecr.object_version_number
2747: from ben_enrt_rt ecr
2748: where elig_per_elctbl_chc_id in
2749: (select elig_per_elctbl_chc_id
2750: from ben_elig_per_elctbl_chc
2751: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2752: or enrt_bnft_id in
2753: (select enrt_bnft_id
2754: from ben_enrt_bnft

Line 2763: from ben_elig_per_elctbl_chc

2759: ecr.object_version_number
2760: from ben_enrt_rt ecr
2761: where elig_per_elctbl_chc_id in
2762: (select elig_per_elctbl_chc_id
2763: from ben_elig_per_elctbl_chc
2764: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2765: UNION all
2766: select ecr.enrt_rt_id,
2767: ecr.object_version_number

Line 2781: from ben_elig_per_elctbl_chc

2777: enb.object_version_number
2778: from ben_enrt_bnft enb
2779: where elig_per_elctbl_chc_id in
2780: (select elig_per_elctbl_chc_id
2781: from ben_elig_per_elctbl_chc
2782: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id);
2783:
2784: --
2785: begin