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_PL_NIP_ENRT_F

Line 22: p_pl_id IN ben_ler_chg_pl_nip_enrt_f.pl_id%TYPE,

18: Re-wrote cursor c_getpenesd in plsql.
19: */
20: -------------------------------------------------------------------------------
21: PROCEDURE determine_ben_settings(
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,

Line 23: p_ler_id IN ben_ler_chg_pl_nip_enrt_f.ler_id%TYPE,

19: */
20: -------------------------------------------------------------------------------
21: PROCEDURE determine_ben_settings(
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,

Line 113: FROM ben_ler_chg_pl_nip_enrt_f pl_nip

109: pl_nip.enrt_rl,
110: pl_nip.ler_chg_pl_nip_enrt_id,
111: pl_nip.stl_elig_cant_chg_flag,
112: pl_nip.tco_chg_enrt_cd
113: FROM ben_ler_chg_pl_nip_enrt_f pl_nip
114: WHERE pl_nip.pl_id = p_pl_id
115: AND pl_nip.ler_id = p_ler_id
116: AND p_lf_evt_ocrd_dt BETWEEN pl_nip.effective_start_date
117: AND pl_nip.effective_end_date;

Line 136: pnip_auto_enrt_mthd_rl ben_ler_chg_pl_nip_enrt_f.auto_enrt_mthd_rl%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;
140: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%TYPE;

Line 137: pnip_crnt_enrt_prclds_chg_flag ben_ler_chg_pl_nip_enrt_f.crnt_enrt_prclds_chg_flag%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;
140: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%TYPE;
141: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_rl%TYPE;

Line 138: pnip_dflt_flag ben_ler_chg_pl_nip_enrt_f.dflt_flag%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;
140: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;

Line 139: pnip_enrt_cd ben_ler_chg_pl_nip_enrt_f.enrt_cd%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;
140: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;

Line 140: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;
140: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;

Line 141: pnip_enrt_rl ben_ler_chg_pl_nip_enrt_f.enrt_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;
140: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;

Line 142: pnip_ler_chg_pnip_enrt_id ben_ler_chg_pl_nip_enrt_f.ler_chg_pl_nip_enrt_id%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;
140: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;

Line 143: pnip_stl_elig_cant_chg_flag ben_ler_chg_pl_nip_enrt_f.stl_elig_cant_chg_flag%TYPE;

139: pnip_enrt_cd ben_ler_chg_pl_nip_enrt_f.enrt_cd%TYPE;
140: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;

Line 144: pnip_tco_chg_enrt_cd ben_ler_chg_pl_nip_enrt_f.tco_chg_enrt_cd%TYPE;

140: pnip_enrt_mthd_cd ben_ler_chg_pl_nip_enrt_f.enrt_mthd_cd%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;