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 3202: from ben_elig_per_elctbl_chc epe

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

Line 3397: from ben_elig_per_elctbl_chc epe

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

Line 3617: from ben_elig_per_elctbl_chc epe

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

Line 7181: from ben_elig_per_elctbl_chc epe,

7177: epe.ptip_id,
7178: epe.oiplip_id,
7179: pil.ler_id,
7180: pil.per_in_ler_id
7181: from ben_elig_per_elctbl_chc epe,
7182: ben_per_in_ler pil
7183: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
7184: and epe.per_in_ler_id = pil.per_in_ler_id;
7185: --