APPS.BEN_PST_BUS dependencies on BEN_PSTN_RT_F

Line 150: ben_pst_shd.constraint_error('BEN_PSTN_RT_F_FK3');

146: --
147: -- raise error as FK does not relate to PK in
148: -- per_abs_attendance_reasons table.
149: --
150: ben_pst_shd.constraint_error('BEN_PSTN_RT_F_FK3');
151: --
152: end if;
153: --
154: close c1;

Line 209: from ben_pstn_rt_f

205: l_exists varchar2(1);
206: --
207: cursor c_dup is
208: select null
209: from ben_pstn_rt_f
210: where position_id = p_position_id
211: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
212: and pstn_rt_id <> nvl(p_pstn_rt_id,hr_api.g_number)
213: and business_group_id + 0 = p_business_group_id

Line 361: from ben_pstn_rt_f

357: is
358: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
359: l_dummy char(1);
360: cursor c1 is select null
361: from ben_pstn_rt_f
362: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
363: -- changed against bug: 5113011
364: and pstn_rt_id <> nvl(p_pstn_rt_id ,-1)
365: -- and position_id <> nvl(p_position_id ,-1)

Line 761: ben_pstn_rt_f b

757: --
758: cursor csr_leg_code is
759: select a.legislation_code
760: from per_business_groups a,
761: ben_pstn_rt_f b
762: where b.pstn_rt_id = p_pstn_rt_id
763: and a.business_group_id = b.business_group_id;
764: --
765: -- Declare local variables