APPS.BEN_LMM_BUS dependencies on BEN_LBR_MMBR_RT_F

Line 196: from ben_lbr_mmbr_rt_f

192: l_exists varchar2(1);
193: --
194: cursor c_dup is
195: select null
196: from ben_lbr_mmbr_rt_f
197: where lbr_mmbr_flag = p_lbr_mmbr_flag
198: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
199: and lbr_mmbr_rt_id <> nvl(p_lbr_mmbr_rt_id,hr_api.g_number)
200: and business_group_id + 0 = p_business_group_id

Line 272: from ben_lbr_mmbr_rt_f

268: is
269: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
270: l_dummy char(1);
271: cursor c1 is select null
272: from ben_lbr_mmbr_rt_f
273: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
274: and lbr_mmbr_rt_id <> nvl(p_lbr_mmbr_rt_id,-1)
275: and p_effective_date between effective_start_date
276: and effective_end_date

Line 728: ben_lbr_mmbr_rt_f b

724: --
725: cursor csr_leg_code is
726: select a.legislation_code
727: from per_business_groups a,
728: ben_lbr_mmbr_rt_f b
729: where b.lbr_mmbr_rt_id = p_lbr_mmbr_rt_id
730: and a.business_group_id = b.business_group_id;
731: --
732: -- Declare local variables