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_PTIP_ENRT_F

Line 25: p_ptip_id IN ben_ler_chg_ptip_enrt_f.ptip_id%TYPE,

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,
28: p_oipl_id IN ben_ler_chg_oipl_enrt_f.oipl_id%TYPE,
29: p_just_prclds_chg_flag IN BOOLEAN DEFAULT FALSE,

Line 37: p_tco_chg_enrt_cd OUT NOCOPY ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%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
41: -- ========================

Line 81: FROM ben_ler_chg_ptip_enrt_f ptip

77: ptip.enrt_rl,
78: ptip.ler_chg_ptip_enrt_id,
79: ptip.stl_elig_cant_chg_flag,
80: ptip.tco_chg_enrt_cd
81: FROM ben_ler_chg_ptip_enrt_f ptip
82: WHERE ptip.ptip_id = p_ptip_id
83: AND ptip.ler_id = p_ler_id
84: AND p_lf_evt_ocrd_dt BETWEEN ptip.effective_start_date
85: AND ptip.effective_end_date;

Line 154: ptip_crnt_enrt_prclds_chg_flag ben_ler_chg_ptip_enrt_f.crnt_enrt_prclds_chg_flag%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;
158: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;

Line 155: ptip_enrt_cd ben_ler_chg_ptip_enrt_f.enrt_cd%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;
158: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
159: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;

Line 156: ptip_enrt_mthd_cd ben_ler_chg_ptip_enrt_f.enrt_mthd_cd%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;
158: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
159: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
160: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;

Line 157: ptip_enrt_rl ben_ler_chg_ptip_enrt_f.enrt_rl%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;
158: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
159: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
160: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
161: BEGIN

Line 158: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%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;
158: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
159: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
160: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
161: BEGIN
162: --

Line 159: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_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;
158: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
159: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
160: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
161: BEGIN
162: --
163: g_debug := hr_utility.debug_enabled;

Line 160: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_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;
158: ptip_ler_chg_ptip_enrt_id ben_ler_chg_ptip_enrt_f.ler_chg_ptip_enrt_id%TYPE;
159: ptip_stl_elig_cant_chg_flag ben_ler_chg_ptip_enrt_f.stl_elig_cant_chg_flag%TYPE;
160: ptip_tco_chg_enrt_cd ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE;
161: BEGIN
162: --
163: g_debug := hr_utility.debug_enabled;
164: --