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_OIPL_ENRT_F

Line 28: p_oipl_id IN ben_ler_chg_oipl_enrt_f.oipl_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,

Line 30: p_enrt_cd OUT NOCOPY ben_ler_chg_oipl_enrt_f.enrt_cd%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,

Line 31: p_enrt_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.enrt_rl%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,

Line 32: p_auto_enrt_mthd_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%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,

Line 33: p_crnt_enrt_prclds_chg_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%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,

Line 34: p_dflt_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE,

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,

Line 36: p_stl_elig_cant_chg_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%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,
40: p_enrt_cd_level OUT NOCOPY VARCHAR2 ) IS

Line 53: FROM ben_ler_chg_oipl_enrt_f oipl

49: oipl.enrt_cd,
50: oipl.enrt_rl,
51: oipl.ler_chg_oipl_enrt_id,
52: oipl.stl_elig_cant_chg_flag
53: FROM ben_ler_chg_oipl_enrt_f oipl
54: WHERE oipl.oipl_id = p_oipl_id
55: AND oipl.ler_id = p_ler_id
56: AND p_lf_evt_ocrd_dt BETWEEN oipl.effective_start_date
57: AND oipl.effective_end_date;

Line 121: oipl_auto_enrt_flag ben_ler_chg_oipl_enrt_f.auto_enrt_flag%TYPE;

117: AND pl_nip.effective_end_date;
118: -- ======================
119: -- define local variables
120: -- ======================
121: oipl_auto_enrt_flag ben_ler_chg_oipl_enrt_f.auto_enrt_flag%TYPE;
122: oipl_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
123: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
124: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;
125: oipl_enrt_cd ben_ler_chg_oipl_enrt_f.enrt_cd%TYPE;

Line 122: oipl_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;

118: -- ======================
119: -- define local variables
120: -- ======================
121: oipl_auto_enrt_flag ben_ler_chg_oipl_enrt_f.auto_enrt_flag%TYPE;
122: oipl_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
123: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
124: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;
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;

Line 123: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;

119: -- define local variables
120: -- ======================
121: oipl_auto_enrt_flag ben_ler_chg_oipl_enrt_f.auto_enrt_flag%TYPE;
122: oipl_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
123: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
124: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;
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;

Line 124: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;

120: -- ======================
121: oipl_auto_enrt_flag ben_ler_chg_oipl_enrt_f.auto_enrt_flag%TYPE;
122: oipl_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
123: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
124: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;
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;

Line 125: oipl_enrt_cd ben_ler_chg_oipl_enrt_f.enrt_cd%TYPE;

121: oipl_auto_enrt_flag ben_ler_chg_oipl_enrt_f.auto_enrt_flag%TYPE;
122: oipl_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
123: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
124: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;
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;

Line 126: oipl_enrt_rl ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE;

122: oipl_auto_enrt_mthd_rl ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE;
123: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
124: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;
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;

Line 127: oipl_ler_chg_oipl_enrt_id ben_ler_chg_oipl_enrt_f.ler_chg_oipl_enrt_id%TYPE;

123: oipl_crnt_enrt_prclds_chg_flag ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE;
124: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;
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;

Line 128: oipl_stl_elig_cant_chg_flag ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE;

124: oipl_dflt_flag ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE;
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;