APPS.BEN_DETERMINE_ELIGIBILITY dependencies on BEN_PL_F

Line 74: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%type;

70: l_dpnt_elig_flag varchar2(1) := 'Y';
71: l_dependent_elig_flag varchar2(1) := 'Y';
72: l_dpnt_inelig_rsn_cd ben_elig_dpnt.inelg_rsn_cd%type;
73: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
74: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%type;
75: l_elig_inelig_cd ben_elig_to_prte_rsn_f.elig_inelig_cd%type;
76: l_dpnt_pl_id ben_pl_f.pl_id%type;
77: l_exists varchar2(30);
78: --

Line 76: l_dpnt_pl_id ben_pl_f.pl_id%type;

72: l_dpnt_inelig_rsn_cd ben_elig_dpnt.inelg_rsn_cd%type;
73: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%type;
74: l_per_cvrd_cd ben_pl_f.per_cvrd_cd%type;
75: l_elig_inelig_cd ben_elig_to_prte_rsn_f.elig_inelig_cd%type;
76: l_dpnt_pl_id ben_pl_f.pl_id%type;
77: l_exists varchar2(30);
78: --
79: l_terminated per_assignment_status_types.per_system_status%type;
80: l_assignment_id per_all_assignments_f.assignment_id%type;

Line 84: l_pl2_rec ben_pl_f%rowtype;

80: l_assignment_id per_all_assignments_f.assignment_id%type;
81: l_found_profile varchar2(1) := 'N';
82: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
83: l_pl_rec ben_cobj_cache.g_pl_inst_row;
84: l_pl2_rec ben_pl_f%rowtype;
85: l_pl3_rec ben_pl_f%rowtype;
86: l_ptip2_rec ben_ptip_f%rowtype;
87: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
88: l_plip_rec ben_cobj_cache.g_plip_inst_row;

Line 85: l_pl3_rec ben_pl_f%rowtype;

81: l_found_profile varchar2(1) := 'N';
82: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
83: l_pl_rec ben_cobj_cache.g_pl_inst_row;
84: l_pl2_rec ben_pl_f%rowtype;
85: l_pl3_rec ben_pl_f%rowtype;
86: l_ptip2_rec ben_ptip_f%rowtype;
87: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
88: l_plip_rec ben_cobj_cache.g_plip_inst_row;
89: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;

Line 169: ben_pl_f pln

165: --
166: cursor c_plip_pl_typ(c_effective_date date) is
167: select pln.pl_typ_id
168: from ben_plip_f plip,
169: ben_pl_f pln
170: where plip_id = p_plip_id
171: and c_effective_date
172: between plip.effective_start_date and plip.effective_end_date
173: and pln.pl_id = plip.pl_id

Line 180: ben_pl_f pln

176: --
177: cursor c_oipl_pl_typ(c_effective_date date) is
178: select pln.pl_typ_id
179: from ben_oipl_f oipl,
180: ben_pl_f pln
181: where oipl_id = p_oipl_id
182: and c_effective_date
183: between oipl.effective_start_date and oipl.effective_end_date
184: and pln.pl_id = oipl.pl_id

Line 214: l_pln_rec ben_pl_f%rowtype;

210: l_benmngle_parm_rec benutils.g_batch_param_rec;
211: --
212: l_score_tab ben_evaluate_elig_profiles.scoreTab;
213: l_ctp_rec ben_ptip_f%rowtype;
214: l_pln_rec ben_pl_f%rowtype;
215: begin
216: --
217: g_debug := hr_utility.debug_enabled;
218: --