APPS.BEN_LAR_BUS dependencies on BEN_LOA_RSN_RT_F

Line 201: from ben_loa_rsn_rt_f

197: l_exists varchar2(1);
198: --
199: cursor c_dup is
200: select null
201: from ben_loa_rsn_rt_f
202: where -- loa_rsn_cd = p_loa_rsn_cd and
203: absence_attendance_type_id = p_absence_attendance_type_id
204: and nvl(abs_attendance_reason_id,-1) = nvl(p_abs_attendance_reason_id,-1)
205: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id

Line 281: from ben_loa_rsn_rt_f

277: is
278: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
279: l_dummy char(1);
280: cursor c1 is select null
281: from ben_loa_rsn_rt_f
282: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
283: and loa_rsn_rt_id<> nvl(p_loa_rsn_rt_id,-1)
284: and p_effective_date between effective_start_date
285: and effective_end_date

Line 442: ben_lar_shd.constraint_error('BEN_LOA_RSN_RT_F_FK2');

438: --
439: -- raise error as FK does not relate to PK in
440: -- per_absence_attendance_types table.
441: --
442: ben_lar_shd.constraint_error('BEN_LOA_RSN_RT_F_FK2');
443: --
444: end if;
445: --
446: close c1;

Line 522: ben_lar_shd.constraint_error('BEN_LOA_RSN_RT_F_FK3');

518: --
519: -- raise error as FK does not relate to PK in
520: -- per_abs_attendance_reasons table.
521: --
522: ben_lar_shd.constraint_error('BEN_LOA_RSN_RT_F_FK3');
523: --
524: end if;
525: --
526: close c1;

Line 931: ben_loa_rsn_rt_f b

927: --
928: cursor csr_leg_code is
929: select a.legislation_code
930: from per_business_groups a,
931: ben_loa_rsn_rt_f b
932: where b.loa_rsn_rt_id = p_loa_rsn_rt_id
933: and a.business_group_id = b.business_group_id;
934: --
935: -- Declare local variables