eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_VPF_BUS dependencies on BEN_ELIG_TTL_CVG_VOL_PRTE_F

Line 2540: -- Coverage Flag is Y then a BEN_ELIG_TTL_CVG_VOL_PRTE_F record must have

2536: -- Bug : 3456400
2537: --
2538: -- Description
2539: -- This procedure is used to check that if the Always Sum All
2540: -- Coverage Flag is Y then a BEN_ELIG_TTL_CVG_VOL_PRTE_F record must have
2541: -- been defined with the record (ELPRO) attached to Variable Rate Profile
2542: -- (VAPRO) identified by p_vrbl_rt_prfl_id.
2543: --
2544: -- Pre Conditions

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