APPS.BEN_LRN_BUS dependencies on BEN_LVG_RSN_RT_F

Line 120: from ben_lvg_rsn_rt_f lrn

116: l_exists varchar2(1);
117: --
118: cursor c3 is
119: select null
120: from ben_lvg_rsn_rt_f lrn
121: where lrn.lvg_rsn_cd = p_lvg_rsn_cd
122: and lrn.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
123: and lrn.lvg_rsn_rt_id <> nvl(p_lvg_rsn_rt_id,hr_api.g_number)
124: and lrn.business_group_id + 0 = p_business_group_id

Line 294: from ben_lvg_rsn_rt_f

290: is
291: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
292: l_dummy char(1);
293: cursor c1 is select null
294: from ben_lvg_rsn_rt_f
295: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
296: -- changed against bug: 5113011
297: and lvg_rsn_rt_id <> nvl(p_lvg_rsn_rt_id ,-1)
298: -- and lvg_rsn_cd <> nvl(p_lvg_rsn_cd ,-1)

Line 679: ben_lvg_rsn_rt_f b

675: --
676: cursor csr_leg_code is
677: select a.legislation_code
678: from per_business_groups a,
679: ben_lvg_rsn_rt_f b
680: where b.lvg_rsn_rt_id = p_lvg_rsn_rt_id
681: and a.business_group_id = b.business_group_id;
682: --
683: -- Declare local variables