APPS.BEN_AVR_BUS dependencies on BEN_ACTY_BASE_RT_F

Line 115: from ben_acty_base_rt_f

111: is
112: l_proc varchar2(72) := g_package||' chk_vrbl_rt_not_allowed ';
113: l_dummy char(1);
114: cursor c1 is select null
115: from ben_acty_base_rt_f
116: where acty_base_rt_id = p_acty_base_rt_id
117: -- and flx_cr_rt_flag = 'Y'
118: and USES_VARBL_RT_FLAG = 'N'
119: and business_group_id + 0 = p_business_group_id

Line 364: 'Y' from ben_acty_base_rt_f abr

360: is
361: l_proc varchar2(72) := g_package||' chk_vrbl_rt_cd_for_imput_pln ';
362: l_dummy char(1);
363: cursor c1 is select
364: 'Y' from ben_acty_base_rt_f abr
365: where abr.acty_base_rt_id=p_acty_base_rt_id
366: and abr.business_group_id=p_business_group_id
367: and abr.rt_usg_cd='IMPTDINC'
368: and p_effective_date between effective_start_date and effective_end_date;

Line 544: (p_base_table_name => 'ben_acty_base_rt_f',

540: p_argument_value => p_validation_end_date);
541: --
542: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
543: NOT (dt_api.check_min_max_dates
544: (p_base_table_name => 'ben_acty_base_rt_f',
545: p_base_key_column => 'acty_base_rt_id',
546: p_base_key_value => p_acty_base_rt_id,
547: p_from_date => p_validation_start_date,
548: p_to_date => p_validation_end_date))) Then

Line 549: l_table_name := 'ben_acty_base_rt_f';

545: p_base_key_column => 'acty_base_rt_id',
546: p_base_key_value => p_acty_base_rt_id,
547: p_from_date => p_validation_start_date,
548: p_to_date => p_validation_end_date))) Then
549: l_table_name := 'ben_acty_base_rt_f';
550: Raise l_integrity_error;
551: End If;
552: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
553: NOT (dt_api.check_min_max_dates