APPS.BEN_DETERMINE_COVERAGE dependencies on BEN_ELCTBL_CHC_CTFN

Line 395: present in ben_elctbl_chc_ctfn table.

391: 01-Jul-2010 velvanop 120.31.12010000.14 Bug 9774647:When salary change event occurs, update the coverage amount of the interim with the newly calculated value
392: 17-Feb-2011 amnaraya 120.31.12010000.15 Bug #8501248: Set the min, max, increment and default values as well as the enter value at enrollment flag for the variable
393: coverage profile with calculation method NSVU
394: 06-Jun-2011 usaraswa 120.31.12010000.16 Bug 14137476: If the benefit amount is enter value at enrollment then for the elig_per_elctbl_chc_id there should be a record
395: present in ben_elctbl_chc_ctfn table.
396: */
397: -------------------------------------------------------------------------------------------------------------------------------------------------
398: --
399: g_package varchar2(80) := 'ben_determine_coverage';

Line 2085: FROM ben_elctbl_chc_ctfn ecc

2081: -- cursor c_prev_le_cert(p_business_group_id number,p_epe_id number) is
2082: ---Bug 8767376
2083: cursor c_prev_le_cert(p_business_group_id number,p_epe_id number,p_val number) is
2084: SELECT ecc.*
2085: FROM ben_elctbl_chc_ctfn ecc
2086: WHERE ecc.business_group_id = p_business_group_id
2087: AND ecc.elig_per_elctbl_chc_id = p_epe_id
2088: ---Added for the bug 8767376
2089: and l_cvg(0).cvg_mlt_cd not in ('CLRNG','FLPCLRNG','CLPFLRNG','FLRNG')

Line 2092: FROM ben_elctbl_chc_ctfn ecc,

2088: ---Added for the bug 8767376
2089: and l_cvg(0).cvg_mlt_cd not in ('CLRNG','FLPCLRNG','CLPFLRNG','FLRNG')
2090: union
2091: SELECT ecc.*
2092: FROM ben_elctbl_chc_ctfn ecc,
2093: ben_enrt_bnft enb
2094: WHERE ecc.elig_per_elctbl_chc_id = p_epe_id
2095: AND ecc.business_group_id = p_business_group_id
2096: AND enb.business_group_id = ecc.business_group_id

Line 2107: FROM ben_elctbl_chc_ctfn ecc,

2103: l_prev_le_cert c_prev_le_cert%rowtype;
2104:
2105: cursor c_chk_bnft_cert(p_business_group_id number) is
2106: SELECT NULL
2107: FROM ben_elctbl_chc_ctfn ecc,
2108: ben_enrt_bnft enb ---Added for the bug 8767376
2109: WHERE ecc.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
2110: AND ecc.business_group_id = p_business_group_id
2111: ---Added for the bug 8767376