DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ELIGIBILITY dependencies on BEN_PTIP_F

Line 86: l_ptip2_rec ben_ptip_f%rowtype;

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;
90: l_elig_to_prte_rsn_row ben_cobj_cache.g_etpr_inst_row;

Line 160: from ben_ptip_f

156:
157: -- bug # 2424041 begins
158: cursor c_ptip_pl_typ(c_effective_date date) is
159: select pl_typ_id
160: from ben_ptip_f
161: where ptip_id = p_ptip_id
162: and c_effective_date
163: between effective_start_date
164: and effective_end_date;

Line 213: l_ctp_rec ben_ptip_f%rowtype;

209: l_env_rec ben_env_object.g_global_env_rec_type;
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: l_all_inelig varchar2(1);
216: begin
217: --