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_ENROLMENT_REQUIREMENTS1 dependencies on BEN_LER_CHG_PLIP_ENRT_F

Line 27: p_plip_id IN ben_ler_chg_plip_enrt_f.plip_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,

Line 97: FROM ben_ler_chg_plip_enrt_f plip

93: plip.enrt_rl,
94: plip.ler_chg_plip_enrt_id,
95: plip.stl_elig_cant_chg_flag,
96: plip.tco_chg_enrt_cd
97: FROM ben_ler_chg_plip_enrt_f plip
98: WHERE plip.plip_id = p_plip_id
99: AND plip.ler_id = p_ler_id
100: AND p_lf_evt_ocrd_dt BETWEEN plip.effective_start_date
101: AND plip.effective_end_date;

Line 145: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;

141: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_rl%TYPE;
142: pnip_ler_chg_pnip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;
143: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;
144: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;
145: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;
146: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
147: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
148: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
149: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;

Line 146: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;

142: pnip_ler_chg_pnip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%TYPE;
143: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;
144: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;
145: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;
146: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
147: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
148: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
149: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;
150: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_rl%TYPE;

Line 147: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;

143: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;
144: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;
145: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;
146: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
147: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
148: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
149: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;
150: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_rl%TYPE;
151: plip_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;

Line 148: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;

144: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;
145: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;
146: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
147: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
148: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
149: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;
150: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_rl%TYPE;
151: plip_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;
152: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;

Line 149: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;

145: plip_auto_enrt_mthd_rl ben_ler_chg_plip_enrt_f.auto_enrt_mthd_rl%TYPE;
146: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
147: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
148: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
149: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;
150: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_rl%TYPE;
151: plip_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;
152: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;
153: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;

Line 150: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_rl%TYPE;

146: plip_crnt_enrt_prclds_chg_flag ben_ler_chg_plip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
147: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
148: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
149: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;
150: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_rl%TYPE;
151: plip_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;
152: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;
153: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;
154: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;

Line 151: plip_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;

147: plip_dflt_flag ben_ler_chg_plip_enrt_f.dflt_flag%TYPE;
148: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
149: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;
150: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_rl%TYPE;
151: plip_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;
152: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;
153: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;
154: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
155: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;

Line 152: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;

148: plip_enrt_cd ben_ler_chg_plip_enrt_f.enrt_cd%TYPE;
149: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;
150: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_rl%TYPE;
151: plip_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;
152: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;
153: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;
154: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
155: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;
156: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;

Line 153: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;

149: plip_enrt_mthd_cd ben_ler_chg_plip_enrt_f.enrt_mthd_cd%TYPE;
150: plip_enrt_rl ben_ler_chg_plip_enrt_f.enrt_rl%TYPE;
151: plip_ler_chg_plip_enrt_id ben_ler_chg_plip_enrt_f.ler_chg_plip_enrt_id%TYPE;
152: plip_stl_elig_cant_chg_flag ben_ler_chg_plip_enrt_f.stl_elig_cant_chg_flag%TYPE;
153: plip_tco_chg_enrt_cd ben_ler_chg_plip_enrt_f.tco_chg_enrt_cd%TYPE;
154: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
155: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%TYPE;
156: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%TYPE;
157: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%TYPE;