APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 2967: from ben_elig_per_elctbl_chc epe

2963: -- Grab needed parameters for passing into determin_age procedure.
2964: --
2965: cursor c_age_param is
2966: select epe.pl_id, epe.pgm_id, epe.oipl_id, epe.per_in_ler_id
2967: from ben_elig_per_elctbl_chc epe
2968: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
2969: --
2970: l_inst_set ben_rt_prfl_cache.g_age_inst_tbl;
2971: l_inst_count number;

Line 3204: from ben_elig_per_elctbl_chc epe

3200: -- Grab needed parameters for passing into determin_age procedure.
3201: --
3202: cursor c_comp_param is
3203: select epe.pl_id, epe.pgm_id, epe.oipl_id, epe.per_in_ler_id
3204: from ben_elig_per_elctbl_chc epe
3205: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
3206: --
3207: l_proc varchar2(80) := g_package||'.check_comp_level';
3208: l_inst_set ben_rt_prfl_cache.g_complvl_inst_tbl;

Line 3399: from ben_elig_per_elctbl_chc epe

3395: -- Grab needed parameters for accessing LOS_VAL.
3396: --
3397: cursor c_elect is
3398: select epe.pl_id, epe.pgm_id, epe.oipl_id, epe.per_in_ler_id
3399: from ben_elig_per_elctbl_chc epe
3400: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
3401: --
3402: l_inst_set ben_rt_prfl_cache.g_los_inst_tbl;
3403: l_inst_count number;

Line 3621: from ben_elig_per_elctbl_chc epe

3617: -- Grab needed parameters for accessing CMBN_AGE_N_LOS_VAL .
3618: --
3619: cursor c_elect is
3620: select epe.pl_id, epe.pgm_id, epe.oipl_id, epe.per_in_ler_id
3621: from ben_elig_per_elctbl_chc epe
3622: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
3623: --
3624: l_inst_set ben_rt_prfl_cache.g_age_los_inst_tbl;
3625: l_inst_count number;

Line 7238: from ben_elig_per_elctbl_chc epe,

7234: epe.ptip_id,
7235: epe.oiplip_id,
7236: pil.ler_id,
7237: pil.per_in_ler_id
7238: from ben_elig_per_elctbl_chc epe,
7239: ben_per_in_ler pil
7240: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
7241: and epe.per_in_ler_id = pil.per_in_ler_id;
7242: --