DBA Data[Home] [Help]

APPS.BEN_VPF_BUS dependencies on BEN_TTL_CVG_VOL_RT_F

Line 2504: from ben_ttl_cvg_vol_rt_f

2500: --
2501: l_proc varchar2(72) := g_package||'chk_alwys_sum_all_cvg_def';
2502: l_dummy char(1);
2503: cursor c1 is select null
2504: from ben_ttl_cvg_vol_rt_f
2505: Where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
2506: and business_group_id = p_business_group_id
2507: and p_effective_date between effective_start_date
2508: and effective_end_date;

Line 2733: from ben_ttl_cvg_vol_rt_f a

2729: l_dummy varchar2(1);
2730: --
2731: cursor c1 is
2732: select null
2733: from ben_ttl_cvg_vol_rt_f a
2734:
2735: where a.business_group_id +0 = p_business_group_id
2736: and a.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
2737: and p_effective_date

Line 4636: (p_base_table_name => 'ben_ttl_cvg_vol_rt_f',

4632: End If;
4633: --
4634: --
4635: If (dt_api.rows_exist
4636: (p_base_table_name => 'ben_ttl_cvg_vol_rt_f',
4637: p_base_key_column => 'vrbl_rt_prfl_id',
4638: p_base_key_value => p_vrbl_rt_prfl_id,
4639: p_from_date => p_validation_start_date,
4640: p_to_date => p_validation_end_date)) Then

Line 4641: l_table_name := 'ben_ttl_cvg_vol_rt_f';

4637: p_base_key_column => 'vrbl_rt_prfl_id',
4638: p_base_key_value => p_vrbl_rt_prfl_id,
4639: p_from_date => p_validation_start_date,
4640: p_to_date => p_validation_end_date)) Then
4641: l_table_name := 'ben_ttl_cvg_vol_rt_f';
4642: Raise l_rows_exist;
4643: End If;
4644: --
4645: --