APPS.BEN_FTR_BUS dependencies on BEN_FL_TM_PT_TM_RT_F

Line 199: from ben_fl_tm_pt_tm_rt_f

195: l_exists varchar2(1);
196: --
197: cursor c_dup is
198: select null
199: from ben_fl_tm_pt_tm_rt_f
200: where fl_tm_pt_tm_cd = p_fl_tm_pt_tm_cd
201: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
202: and fl_tm_pt_tm_rt_id <> nvl(p_fl_tm_pt_tm_rt_id,hr_api.g_number)
203: and business_group_id + 0 = p_business_group_id

Line 275: from ben_fl_tm_pt_tm_rt_f

271: is
272: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
273: l_dummy char(1);
274: cursor c1 is select null
275: from ben_fl_tm_pt_tm_rt_f
276: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
277: and fl_tm_pt_tm_rt_id <> nvl(p_fl_tm_pt_tm_rt_id,-1)
278: and p_effective_date between effective_start_date
279: and effective_end_date

Line 733: ben_fl_tm_pt_tm_rt_f b

729: --
730: cursor csr_leg_code is
731: select a.legislation_code
732: from per_business_groups a,
733: ben_fl_tm_pt_tm_rt_f b
734: where b.fl_tm_pt_tm_rt_id = p_fl_tm_pt_tm_rt_id
735: and a.business_group_id = b.business_group_id;
736: --
737: -- Declare local variables