APPS.BEN_EAR_BUS dependencies on BEN_ENRLD_ANTHR_PLIP_RT_F

Line 129: from ben_enrld_anthr_plip_rt_f

125: l_exists varchar2(1);
126: --
127: cursor c_dup is
128: select null
129: from ben_enrld_anthr_plip_rt_f
130: where plip_id = p_plip_id
131: and enrl_det_dt_cd = p_enrl_det_dt_cd
132: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
133: and enrld_anthr_plip_rt_id <> nvl(p_enrld_anthr_plip_rt_id,hr_api.g_number)

Line 360: from ben_enrld_anthr_plip_rt_f

356: is
357: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
358: l_dummy char(1);
359: cursor c1 is select null
360: from ben_enrld_anthr_plip_rt_f
361: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
362: -- changed against bug: 5113011
363: and enrld_anthr_plip_rt_id <> nvl(p_enrld_anthr_plip_rt_id ,-1)
364: -- and plip_id <> nvl(p_plip_id ,-1)

Line 775: ben_enrld_anthr_plip_rt_f b

771: --
772: cursor csr_leg_code is
773: select a.legislation_code
774: from per_business_groups a,
775: ben_enrld_anthr_plip_rt_f b
776: where b.enrld_anthr_plip_rt_id = p_enrld_anthr_plip_rt_id
777: and a.business_group_id = b.business_group_id;
778: --
779: -- Declare local variables