22: p_pl_id IN ben_ler_chg_pl_nip_enrt_f.pl_id%TYPE,
23: p_ler_id IN ben_ler_chg_pl_nip_enrt_f.ler_id%TYPE,
24: p_lf_evt_ocrd_dt IN DATE,
25: p_ptip_id IN ben_ler_chg_ptip_enrt_f.ptip_id%TYPE,
26: p_pgm_id IN ben_ler_chg_pgm_enrt_f.pgm_id%TYPE,
27: p_plip_id IN ben_ler_chg_plip_enrt_f.plip_id%TYPE,
28: p_oipl_id IN ben_ler_chg_oipl_enrt_f.oipl_id%TYPE,
29: p_just_prclds_chg_flag IN BOOLEAN DEFAULT FALSE,
30: p_enrt_cd OUT NOCOPY ben_ler_chg_oipl_enrt_f.enrt_cd%TYPE,
31: p_enrt_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE,
32: p_auto_enrt_mthd_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE,
33: p_crnt_enrt_prclds_chg_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE,
34: p_dflt_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE,
35: p_enrt_mthd_cd OUT NOCOPY ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE,
36: p_stl_elig_cant_chg_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE,
37: p_tco_chg_enrt_cd OUT NOCOPY ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE,
38: p_ler_chg_oipl_found_flag OUT NOCOPY VARCHAR2,
39: p_ler_chg_found_flag OUT NOCOPY VARCHAR2,
63: pgm.enrt_mthd_cd,
64: pgm.enrt_rl,
65: pgm.ler_chg_pgm_enrt_id,
66: pgm.stl_elig_cant_chg_flag
67: FROM ben_ler_chg_pgm_enrt_f pgm
68: WHERE pgm.pgm_id = p_pgm_id
69: AND pgm.ler_id = p_ler_id
70: AND p_lf_evt_ocrd_dt BETWEEN pgm.effective_start_date
71: AND pgm.effective_end_date;
125: oipl_enrt_cd ben_ler_chg_oipl_enrt_f.enrt_cd%TYPE;
126: oipl_enrt_rl ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE;
127: oipl_ler_chg_oipl_enrt_id ben_ler_chg_oipl_enrt_f.ler_chg_oipl_enrt_id%TYPE;
128: oipl_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
129: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
130: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
131: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
132: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
133: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
126: oipl_enrt_rl ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE;
127: oipl_ler_chg_oipl_enrt_id ben_ler_chg_oipl_enrt_f.ler_chg_oipl_enrt_id%TYPE;
128: oipl_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
129: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
130: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
131: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
132: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
133: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
134: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
127: oipl_ler_chg_oipl_enrt_id ben_ler_chg_oipl_enrt_f.ler_chg_oipl_enrt_id%TYPE;
128: oipl_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
129: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
130: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
131: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
132: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
133: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
134: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
135: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;
128: oipl_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;
129: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
130: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
131: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
132: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
133: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
134: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
135: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;
136: pnip_auto_enrt_mthd_rl ben_ler_chg_pl_nip_enrt_f.auto_enrt_mthd_rl%TYPE;
129: pgm_auto_enrt_mthd_rl ben_ler_chg_pgm_enrt_f.auto_enrt_mthd_rl%TYPE;
130: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
131: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
132: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
133: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
134: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
135: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;
136: pnip_auto_enrt_mthd_rl ben_ler_chg_pl_nip_enrt_f.auto_enrt_mthd_rl%TYPE;
137: pnip_crnt_enrt_prclds_chg_flag ben_ler_chg_pl_nip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
130: pgm_crnt_enrt_prclds_chg_flag ben_ler_chg_pgm_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
131: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
132: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
133: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
134: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
135: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;
136: pnip_auto_enrt_mthd_rl ben_ler_chg_pl_nip_enrt_f.auto_enrt_mthd_rl%TYPE;
137: pnip_crnt_enrt_prclds_chg_flag ben_ler_chg_pl_nip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
138: pnip_dflt_flag ben_ler_chg_pl_nip_enrt_f.dflt_flag%TYPE;
131: pgm_enrt_cd ben_ler_chg_pgm_enrt_f.enrt_cd%TYPE;
132: pgm_enrt_mthd_cd ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE;
133: pgm_enrt_rl ben_ler_chg_pgm_enrt_f.enrt_rl%TYPE;
134: pgm_ler_chg_pgm_enrt_id ben_ler_chg_pgm_enrt_f.ler_chg_pgm_enrt_id%TYPE;
135: pgm_stl_elig_cant_chg_flag ben_ler_chg_pgm_enrt_f.stl_elig_cant_chg_flag%TYPE;
136: pnip_auto_enrt_mthd_rl ben_ler_chg_pl_nip_enrt_f.auto_enrt_mthd_rl%TYPE;
137: pnip_crnt_enrt_prclds_chg_flag ben_ler_chg_pl_nip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
138: pnip_dflt_flag ben_ler_chg_pl_nip_enrt_f.dflt_flag%TYPE;
139: pnip_enrt_cd ben_ler_chg_pl_nip_enrt_f.enrt_cd%TYPE;