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_EXT_EVALUATE_INCLUSION dependencies on BEN_PER_IN_LER

Line 2384: FROM ben_per_in_ler pil

2380: is
2381: --
2382: cursor get_per_ler is
2383: SELECT ler_id
2384: FROM ben_per_in_ler pil
2385: WHERE pil.person_id = p_person_id
2386: AND pil.per_in_ler_stat_cd = 'STRTD';
2387: --
2388: l_ler_id ben_per_in_ler.ler_id%type;

Line 2388: l_ler_id ben_per_in_ler.ler_id%type;

2384: FROM ben_per_in_ler pil
2385: WHERE pil.person_id = p_person_id
2386: AND pil.per_in_ler_stat_cd = 'STRTD';
2387: --
2388: l_ler_id ben_per_in_ler.ler_id%type;
2389: --
2390: l_proc varchar2(72);
2391: --
2392: Begin

Line 3221: (p_ler_id in ben_per_in_ler.ler_id%type,

3217: -----------------------------------------------------------------------------
3218: -- The following procedure evaluates ler_name id.
3219: --
3220: Procedure chk_enrt_ler_name_incl
3221: (p_ler_id in ben_per_in_ler.ler_id%type,
3222: p_excld_flag in varchar2)
3223: is
3224: --
3225: l_proc varchar2(72);

Line 3271: (p_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type,

3267: -----------------------------------------------------------------------------
3268: -- The following procedure evaluates per in ler status cd
3269: --
3270: Procedure chk_enrt_ler_stat_incl
3271: (p_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type,
3272: p_excld_flag in varchar2)
3273: is
3274: --
3275: l_proc varchar2(72);

Line 3321: (p_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type,

3317: -----------------------------------------------------------------------------
3318: -- The following procedure evaluates enrt_ler_ocrd_dt id.
3319: --
3320: Procedure chk_enrt_ler_ocrd_dt_incl
3321: (p_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type,
3322: p_effective_date in date,
3323: p_excld_flag in varchar2,
3324: p_pl_id in number default null )
3325: is

Line 3385: (p_ntfn_dt in ben_per_in_ler.ntfn_dt%type,

3381: -----------------------------------------------------------------------------
3382: -- The following procedure evaluates enrt_ler_ntfn_dt id.
3383: --
3384: Procedure chk_enrt_ler_ntfn_dt_incl
3385: (p_ntfn_dt in ben_per_in_ler.ntfn_dt%type,
3386: p_effective_date in date,
3387: p_excld_flag in varchar2,
3388: p_pl_id in number default null )
3389: is

Line 4008: (p_ler_id in ben_per_in_ler.ler_id%type,

4004: -----------------------------------------------------------------------------
4005: -- The following procedure evaluates ler_name id.
4006: --
4007: Procedure chk_elct_ler_name_incl
4008: (p_ler_id in ben_per_in_ler.ler_id%type,
4009: p_excld_flag in varchar2)
4010: is
4011: --
4012: l_proc varchar2(72);

Line 4059: (p_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type,

4055: -----------------------------------------------------------------------------
4056: -- The following procedure evaluates per in ler status cd
4057: --
4058: Procedure chk_elct_ler_stat_incl
4059: (p_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type,
4060: p_excld_flag in varchar2)
4061: is
4062: --
4063: l_proc varchar2(72);

Line 4160: (p_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type,

4156: -----------------------------------------------------------------------------
4157: -- The following procedure evaluates elct_ler_ocrd_dt id.
4158: --
4159: Procedure chk_elct_ler_ocrd_dt_incl
4160: (p_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type,
4161: p_effective_date in date,
4162: p_excld_flag in varchar2,
4163: p_pl_id in number default null )
4164: is

Line 4225: (p_ntfn_dt in ben_per_in_ler.ntfn_dt%type,

4221: -----------------------------------------------------------------------------
4222: -- The following procedure evaluates elct_ler_ntfn_dt id.
4223: --
4224: Procedure chk_elct_ler_ntfn_dt_incl
4225: (p_ntfn_dt in ben_per_in_ler.ntfn_dt%type,
4226: p_effective_date in date,
4227: p_excld_flag in varchar2 ,
4228: p_pl_id in number default null )
4229: is

Line 6329: p_ler_id in ben_per_in_ler.ler_id%type default null,

6325: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type default null,
6326: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type default null,
6327: p_opt_id in ben_opt_f.opt_id%type default null,
6328: p_last_update_date in ben_prtt_enrt_rslt_f.last_update_date%type default null,
6329: p_ler_id in ben_per_in_ler.ler_id%type default null,
6330: p_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,
6331: p_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,
6332: p_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,
6333: p_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,

Line 6330: p_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,

6326: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type default null,
6327: p_opt_id in ben_opt_f.opt_id%type default null,
6328: p_last_update_date in ben_prtt_enrt_rslt_f.last_update_date%type default null,
6329: p_ler_id in ben_per_in_ler.ler_id%type default null,
6330: p_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,
6331: p_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,
6332: p_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,
6333: p_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,
6334: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type default null,

Line 6331: p_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,

6327: p_opt_id in ben_opt_f.opt_id%type default null,
6328: p_last_update_date in ben_prtt_enrt_rslt_f.last_update_date%type default null,
6329: p_ler_id in ben_per_in_ler.ler_id%type default null,
6330: p_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,
6331: p_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,
6332: p_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,
6333: p_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,
6334: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type default null,
6335: p_effective_date in date default null,

Line 6332: p_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,

6328: p_last_update_date in ben_prtt_enrt_rslt_f.last_update_date%type default null,
6329: p_ler_id in ben_per_in_ler.ler_id%type default null,
6330: p_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,
6331: p_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,
6332: p_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,
6333: p_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,
6334: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type default null,
6335: p_effective_date in date default null,
6336: p_dpnt_id in number default null,

Line 6333: p_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,

6329: p_ler_id in ben_per_in_ler.ler_id%type default null,
6330: p_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,
6331: p_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,
6332: p_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,
6333: p_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,
6334: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type default null,
6335: p_effective_date in date default null,
6336: p_dpnt_id in number default null,
6337: p_include out nocopy varchar2)

Line 6485: p_elct_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,

6481: p_elct_pgm_id in ben_elig_per_elctbl_chc.pgm_id%type default null,
6482: p_elct_pl_typ_id in ben_elig_per_elctbl_chc.pl_typ_id%type default null,
6483: p_elct_opt_id in ben_opt_f.opt_id%type default null,
6484: p_elct_last_upd_dt in ben_elig_per_elctbl_chc.last_update_date%type default null,
6485: p_elct_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,
6486: p_elct_ler_id in ben_per_in_ler.ler_id%type default null,
6487: p_elct_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,
6488: p_elct_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,
6489: p_elct_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,

Line 6486: p_elct_ler_id in ben_per_in_ler.ler_id%type default null,

6482: p_elct_pl_typ_id in ben_elig_per_elctbl_chc.pl_typ_id%type default null,
6483: p_elct_opt_id in ben_opt_f.opt_id%type default null,
6484: p_elct_last_upd_dt in ben_elig_per_elctbl_chc.last_update_date%type default null,
6485: p_elct_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,
6486: p_elct_ler_id in ben_per_in_ler.ler_id%type default null,
6487: p_elct_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,
6488: p_elct_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,
6489: p_elct_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,
6490: p_prtt_enrt_rslt_id in ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type default null,

Line 6487: p_elct_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,

6483: p_elct_opt_id in ben_opt_f.opt_id%type default null,
6484: p_elct_last_upd_dt in ben_elig_per_elctbl_chc.last_update_date%type default null,
6485: p_elct_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,
6486: p_elct_ler_id in ben_per_in_ler.ler_id%type default null,
6487: p_elct_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,
6488: p_elct_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,
6489: p_elct_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,
6490: p_prtt_enrt_rslt_id in ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type default null,
6491: p_effective_date in date default null,

Line 6488: p_elct_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,

6484: p_elct_last_upd_dt in ben_elig_per_elctbl_chc.last_update_date%type default null,
6485: p_elct_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,
6486: p_elct_ler_id in ben_per_in_ler.ler_id%type default null,
6487: p_elct_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,
6488: p_elct_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,
6489: p_elct_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,
6490: p_prtt_enrt_rslt_id in ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type default null,
6491: p_effective_date in date default null,
6492: p_include out nocopy varchar2)

Line 6489: p_elct_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,

6485: p_elct_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,
6486: p_elct_ler_id in ben_per_in_ler.ler_id%type default null,
6487: p_elct_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,
6488: p_elct_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,
6489: p_elct_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,
6490: p_prtt_enrt_rslt_id in ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type default null,
6491: p_effective_date in date default null,
6492: p_include out nocopy varchar2)
6493: