APPS.BEN_ABR_BUS dependencies on BEN_ACTY_VRBL_RT_F

Line 1537: from ben_acty_vrbl_rt_f

1533: l_proc varchar2(72) := g_package||'chk_all_flags';
1534: l_api_updating boolean;
1535: l_dummy char(1);
1536: cursor c1 is select null
1537: from ben_acty_vrbl_rt_f
1538: where acty_base_rt_id = p_acty_base_rt_id
1539: and business_group_id = p_business_group_id
1540: and p_effective_date between effective_start_date
1541: and effective_end_date

Line 4316: from ben_acty_vrbl_rt_f

4312: l_return_val boolean := FALSE ;
4313: --
4314: cursor c_fut_var_rt_recs is
4315: select 1
4316: from ben_acty_vrbl_rt_f
4317: where acty_base_rt_id = p_acty_base_rt_id
4318: and effective_start_date <= p_validation_end_date
4319: and effective_end_date >= p_validation_start_date;
4320: --

Line 4763: (p_base_table_name => 'ben_acty_vrbl_rt_f',

4759: l_table_name := 'ben_acty_base_rt_f';
4760: Raise l_rows_exist;
4761: End If;
4762: If (dt_api.rows_exist
4763: (p_base_table_name => 'ben_acty_vrbl_rt_f',
4764: p_base_key_column => 'acty_base_rt_id',
4765: p_base_key_value => p_acty_base_rt_id,
4766: p_from_date => p_validation_start_date,
4767: p_to_date => p_validation_end_date)) Then

Line 4768: l_table_name := 'ben_acty_vrbl_rt_f';

4764: p_base_key_column => 'acty_base_rt_id',
4765: p_base_key_value => p_acty_base_rt_id,
4766: p_from_date => p_validation_start_date,
4767: p_to_date => p_validation_end_date)) Then
4768: l_table_name := 'ben_acty_vrbl_rt_f';
4769: Raise l_rows_exist;
4770: End If;
4771: If (dt_api.rows_exist
4772: (p_base_table_name => 'ben_prtl_mo_rt_prtn_val_f',

Line 4845: l_table_name := 'ben_acty_vrbl_rt_f';

4841: p_datetrack_mode ,
4842: p_validation_start_date ,
4843: p_validation_end_date )
4844: then
4845: l_table_name := 'ben_acty_vrbl_rt_f';
4846: Raise l_rows_exist;
4847: End If;
4848:
4849: