APPS.BEN_VPF_BUS dependencies on BEN_ELIG_TTL_PRTT_PRTE_F

Line 2407: -- Participants Flag is Y then a BEN_ELIG_TTL_PRTT_PRTE_F record must have

2403: -- Bug : 3456400
2404: --
2405: -- Description
2406: -- This procedure is used to check that if the Always Count All
2407: -- Participants Flag is Y then a BEN_ELIG_TTL_PRTT_PRTE_F record must have
2408: -- been defined with the record (ELPRO) being attached to Variable Rate Profile
2409: -- (VAPRO) identified by p_vrbl_rt_prfl_id.
2410: --
2411: -- Pre Conditions

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 2816: -- ben_elig_ttl_prtt_prte_f respectively.

2812: -- Description
2813: -- This procedure is used to check that if the mlt_cd = TTLPRTT or TTLCVG
2814: -- and any Eligibility Profile is defined
2815: -- then none of the Eligibility Profiles must be set up on ben_elig_ttl_cvg_vol_prte or
2816: -- ben_elig_ttl_prtt_prte_f respectively.
2817: --
2818: -- Pre Conditions
2819: -- None.
2820: --

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