APPS.BEN_VPF_BUS dependencies on BEN_VRBL_RT_ELIG_PRFL_F

Line 2438: from ben_elig_ttl_prtt_prte_f etp, ben_vrbl_rt_elig_prfl_f vep

2434: --
2435: l_proc varchar2(72) := g_package||'chk_elig_alwys_cnt_all_prtt_df';
2436: l_dummy char(1);
2437: cursor c1 is select null
2438: from ben_elig_ttl_prtt_prte_f etp, ben_vrbl_rt_elig_prfl_f vep
2439: where vep.eligy_prfl_id = etp.eligy_prfl_id
2440: and vep.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
2441: and vep.business_group_id = p_business_Group_id
2442: and p_effective_date between vep.effective_start_date and vep.effective_end_date

Line 2570: from ben_elig_ttl_cvg_vol_prte_f etc, ben_vrbl_rt_elig_prfl_f vep

2566: --
2567: l_proc varchar2(72) := g_package||'chk_elig_alwys_sum_all_cvg_def';
2568: l_dummy char(1);
2569: cursor c1 is select null
2570: from ben_elig_ttl_cvg_vol_prte_f etc, ben_vrbl_rt_elig_prfl_f vep
2571: where vep.eligy_prfl_id = etc.eligy_prfl_id
2572: and vep.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
2573: and vep.business_group_id = p_business_Group_id
2574: and p_effective_date between vep.effective_start_date and vep.effective_end_date

Line 2846: from ben_elig_ttl_cvg_vol_prte_f etc, ben_vrbl_rt_elig_prfl_f vep

2842: l_api_updating boolean;
2843: l_dummy varchar2(1);
2844: --
2845: cursor c1 is select null
2846: from ben_elig_ttl_cvg_vol_prte_f etc, ben_vrbl_rt_elig_prfl_f vep
2847: where vep.eligy_prfl_id = etc.eligy_prfl_id
2848: and vep.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
2849: and vep.business_group_id = p_business_Group_id
2850: and p_effective_date between vep.effective_start_date and vep.effective_end_date

Line 2855: from ben_elig_ttl_prtt_prte_f etp, ben_vrbl_rt_elig_prfl_f vep

2851: and etc.business_group_id = p_business_Group_id
2852: and p_effective_date between etc.effective_start_date and etc.effective_end_date;
2853: --
2854: cursor c2 is select null
2855: from ben_elig_ttl_prtt_prte_f etp, ben_vrbl_rt_elig_prfl_f vep
2856: where vep.eligy_prfl_id = etp.eligy_prfl_id
2857: and vep.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
2858: and vep.business_group_id = p_business_Group_id
2859: and p_effective_date between vep.effective_start_date and vep.effective_end_date

Line 4058: (p_base_table_name => 'BEN_VRBL_RT_ELIG_PRFL_F',

4054: p_argument => 'vrbl_rt_prfl_id',
4055: p_argument_value => p_vrbl_rt_prfl_id);
4056: --
4057: If (dt_api.rows_exist
4058: (p_base_table_name => 'BEN_VRBL_RT_ELIG_PRFL_F',
4059: p_base_key_column => 'vrbl_rt_prfl_id',
4060: p_base_key_value => p_vrbl_rt_prfl_id,
4061: p_from_date => p_validation_start_date,
4062: p_to_date => p_validation_end_date)) Then

Line 4063: l_table_name := 'BEN_VRBL_RT_ELIG_PRFL_F';

4059: p_base_key_column => 'vrbl_rt_prfl_id',
4060: p_base_key_value => p_vrbl_rt_prfl_id,
4061: p_from_date => p_validation_start_date,
4062: p_to_date => p_validation_end_date)) Then
4063: l_table_name := 'BEN_VRBL_RT_ELIG_PRFL_F';
4064: Raise l_rows_exist;
4065: End If;
4066: --
4067: If (dt_api.rows_exist

Line 4576: (p_base_table_name => 'ben_vrbl_rt_elig_prfl_f',

4572: End If;
4573: --
4574: --
4575: If (dt_api.rows_exist
4576: (p_base_table_name => 'ben_vrbl_rt_elig_prfl_f',
4577: p_base_key_column => 'vrbl_rt_prfl_id',
4578: p_base_key_value => p_vrbl_rt_prfl_id,
4579: p_from_date => p_validation_start_date,
4580: p_to_date => p_validation_end_date)) Then

Line 4581: l_table_name := 'ben_vrbl_rt_elig_prfl_f';

4577: p_base_key_column => 'vrbl_rt_prfl_id',
4578: p_base_key_value => p_vrbl_rt_prfl_id,
4579: p_from_date => p_validation_start_date,
4580: p_to_date => p_validation_end_date)) Then
4581: l_table_name := 'ben_vrbl_rt_elig_prfl_f';
4582: Raise l_rows_exist;
4583: End If;
4584: --
4585: --Bug : 3476138