APPS.BEN_VPF_BUS dependencies on BEN_TTL_PRTT_RT_F

Line 2371: from ben_ttl_prtt_rt_f

2367: --
2368: l_proc varchar2(72) := g_package||'chk_alwys_cnt_all_prtts_def';
2369: l_dummy char(1);
2370: cursor c1 is select null
2371: from ben_ttl_prtt_rt_f
2372: Where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
2373: and business_group_id = p_business_group_id
2374: and p_effective_date between effective_start_date
2375: and effective_end_date;

Line 2743: from ben_ttl_prtt_rt_f a

2739: and a.effective_end_date;
2740: --
2741: cursor c2 is
2742: select null
2743: from ben_ttl_prtt_rt_f a
2744: where a.business_group_id +0 = p_business_group_id
2745: and a.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
2746: and p_effective_date
2747: between a.effective_start_date

Line 4647: (p_base_table_name => 'ben_ttl_prtt_rt_f',

4643: End If;
4644: --
4645: --
4646: If (dt_api.rows_exist
4647: (p_base_table_name => 'ben_ttl_prtt_rt_f',
4648: p_base_key_column => 'vrbl_rt_prfl_id',
4649: p_base_key_value => p_vrbl_rt_prfl_id,
4650: p_from_date => p_validation_start_date,
4651: p_to_date => p_validation_end_date)) Then

Line 4652: l_table_name := 'ben_ttl_prtt_rt_f';

4648: p_base_key_column => 'vrbl_rt_prfl_id',
4649: p_base_key_value => p_vrbl_rt_prfl_id,
4650: p_from_date => p_validation_start_date,
4651: p_to_date => p_validation_end_date)) Then
4652: l_table_name := 'ben_ttl_prtt_rt_f';
4653: Raise l_rows_exist;
4654: End If;
4655: --
4656: --