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 712: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;

708: is
709: --
710: l_proc varchar2(72) ;
711: --
712: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
713: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
714: l_pil_elctbl_chc_popl_id number;
715: l_oiplip_id number;
716: --

Line 713: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;

709: --
710: l_proc varchar2(72) ;
711: --
712: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
713: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
714: l_pil_elctbl_chc_popl_id number;
715: l_oiplip_id number;
716: --
717: begin

Line 1274: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;

1270: l_proc varchar2(72) ;
1271: --
1272: -- Declare cursors and local variables
1273: --
1274: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
1275: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
1276: l_pil_elctbl_chc_popl_id number;
1277: l_oiplip_id number;
1278: --

Line 1275: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;

1271: --
1272: -- Declare cursors and local variables
1273: --
1274: l_elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%TYPE;
1275: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
1276: l_pil_elctbl_chc_popl_id number;
1277: l_oiplip_id number;
1278: --
1279: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;

Line 1279: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;

1275: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
1276: l_pil_elctbl_chc_popl_id number;
1277: l_oiplip_id number;
1278: --
1279: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
1280: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
1281: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
1282: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
1283: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;

Line 1280: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;

1276: l_pil_elctbl_chc_popl_id number;
1277: l_oiplip_id number;
1278: --
1279: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
1280: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
1281: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
1282: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
1283: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
1284: l_elig_flag varchar2(30);

Line 1281: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;

1277: l_oiplip_id number;
1278: --
1279: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
1280: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
1281: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
1282: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
1283: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
1284: l_elig_flag varchar2(30);
1285: l_inelig_rsn_cd varchar2(30);

Line 1282: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;

1278: --
1279: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
1280: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
1281: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
1282: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
1283: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
1284: l_elig_flag varchar2(30);
1285: l_inelig_rsn_cd varchar2(30);
1286: --

Line 1283: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;

1279: l_created_by ben_elig_per_elctbl_chc.created_by%TYPE;
1280: l_creation_date ben_elig_per_elctbl_chc.creation_date%TYPE;
1281: l_last_update_date ben_elig_per_elctbl_chc.last_update_date%TYPE;
1282: l_last_updated_by ben_elig_per_elctbl_chc.last_updated_by%TYPE;
1283: l_last_update_login ben_elig_per_elctbl_chc.last_update_login%TYPE;
1284: l_elig_flag varchar2(30);
1285: l_inelig_rsn_cd varchar2(30);
1286: --
1287: l_sysdate date;

Line 1362: insert into ben_elig_per_elctbl_chc

1358: --
1359: if g_debug then
1360: hr_utility.set_location('Insert EPE: '||l_proc, 5);
1361: end if;
1362: insert into ben_elig_per_elctbl_chc
1363: ( elig_per_elctbl_chc_id,
1364: -- enrt_typ_cycl_cd,
1365: enrt_cvg_strt_dt_cd,
1366: -- enrt_perd_end_dt,

Line 1466: (ben_elig_per_elctbl_chc_s.nextval,

1462: program_update_date,
1463: object_version_number
1464: )
1465: Values
1466: (ben_elig_per_elctbl_chc_s.nextval,
1467: -- p_enrt_typ_cycl_cd,
1468: p_enrt_cvg_strt_dt_cd,
1469: -- p_enrt_perd_end_dt,
1470: -- p_enrt_perd_strt_dt,

Line 1778: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;

1774: --
1775: -- Declare cursors and local variables
1776: --
1777: l_proc varchar2(72) ;
1778: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
1779: --
1780: begin
1781: --
1782: g_debug := hr_utility.debug_enabled;

Line 2188: ben_elig_per_elctbl_chc epe1,

2184: cursor c1 is
2185: select per1.full_name person1,
2186: per2.full_name person2
2187: from ben_cwb_mgr_hrchy cwb1,
2188: ben_elig_per_elctbl_chc epe1,
2189: ben_per_in_ler pil1,
2190: per_all_people_f per1,
2191: per_all_people_f per2
2192: where cwb1.mgr_elig_per_elctbl_chc_id = p_emp_epe_id

Line 2204: from ben_elig_per_elctbl_chc epe2,

2200: and trunc(sysdate) between per2.effective_start_date
2201: and per2.effective_end_date
2202: and exists
2203: ( select 'x'
2204: from ben_elig_per_elctbl_chc epe2,
2205: ben_per_in_ler pil2
2206: where pil2.person_id = p_new_mgr_id
2207: and pil2.lf_evt_ocrd_dt = pil1.lf_evt_ocrd_dt
2208: and pil2.ler_id = pil1.ler_id

Line 2351: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;

2347: -- Declare cursors and local variables
2348: --
2349: l_proc varchar2(72) ;
2350: l_rec ben_epe_shd.g_rec_type;
2351: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
2352: l_elig_flag varchar2(30);
2353: l_inelig_rsn_cd varchar2(30);
2354: --
2355: begin

Line 2522: -- Update the ben_elig_per_elctbl_chc Row

2518: hr_utility.set_location(' EPE Upd'|| l_proc, 10);
2519: end if;
2520: ben_epe_shd.g_api_dml := true; -- Set the api dml status
2521: --
2522: -- Update the ben_elig_per_elctbl_chc Row
2523: --
2524:
2525: update ben_elig_per_elctbl_chc
2526: set

Line 2525: update ben_elig_per_elctbl_chc

2521: --
2522: -- Update the ben_elig_per_elctbl_chc Row
2523: --
2524:
2525: update ben_elig_per_elctbl_chc
2526: set
2527: elig_per_elctbl_chc_id = l_rec.elig_per_elctbl_chc_id,
2528: -- enrt_typ_cycl_cd = l_rec.enrt_typ_cycl_cd,
2529: enrt_cvg_strt_dt_cd = l_rec.enrt_cvg_strt_dt_cd,

Line 2717: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;

2713: --
2714: -- Declare cursors and local variables
2715: --
2716: l_proc varchar2(72) ;
2717: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
2718:
2719: cursor c_ctfn is
2720: /* select ecc.elctbl_chc_ctfn_id,
2721: ecc.object_version_number

Line 2725: from ben_elig_per_elctbl_chc

2721: ecc.object_version_number
2722: from ben_elctbl_chc_ctfn ecc
2723: where elig_per_elctbl_chc_id in
2724: (select elig_per_elctbl_chc_id
2725: from ben_elig_per_elctbl_chc
2726: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2727: or enrt_bnft_id in
2728: (select enrt_bnft_id
2729: from ben_enrt_bnft

Line 2737: from ben_elig_per_elctbl_chc

2733: ecc.object_version_number
2734: from ben_elctbl_chc_ctfn ecc
2735: where elig_per_elctbl_chc_id in
2736: (select elig_per_elctbl_chc_id
2737: from ben_elig_per_elctbl_chc
2738: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2739: UNION
2740: select ecc.elctbl_chc_ctfn_id,
2741: ecc.object_version_number

Line 2755: from ben_elig_per_elctbl_chc

2751: ecr.object_version_number
2752: from ben_enrt_rt ecr
2753: where elig_per_elctbl_chc_id in
2754: (select elig_per_elctbl_chc_id
2755: from ben_elig_per_elctbl_chc
2756: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2757: or enrt_bnft_id in
2758: (select enrt_bnft_id
2759: from ben_enrt_bnft

Line 2768: from ben_elig_per_elctbl_chc

2764: ecr.object_version_number
2765: from ben_enrt_rt ecr
2766: where elig_per_elctbl_chc_id in
2767: (select elig_per_elctbl_chc_id
2768: from ben_elig_per_elctbl_chc
2769: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id)
2770: UNION all
2771: select ecr.enrt_rt_id,
2772: ecr.object_version_number

Line 2786: from ben_elig_per_elctbl_chc

2782: enb.object_version_number
2783: from ben_enrt_bnft enb
2784: where elig_per_elctbl_chc_id in
2785: (select elig_per_elctbl_chc_id
2786: from ben_elig_per_elctbl_chc
2787: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id);
2788:
2789: --
2790: begin