DBA Data[Home] [Help]

APPS.BEN_IRC_UTIL dependencies on BEN_ENRT_RT

Line 417: FROM ben_enrt_rt

413: -- Get the ecr correspoding to past epe
414: CURSOR c_past_ecr (p_past_epe NUMBER)
415: IS
416: SELECT enrt_rt_id, val, cmcd_val, ann_val
417: FROM ben_enrt_rt
418: WHERE elig_per_elctbl_chc_id = p_past_epe
419: AND entr_val_at_enrt_flag = 'Y'
420: AND p_business_group_id = p_business_group_id;
421:

Line 428: FROM ben_enrt_rt

424: -- Get the ecr correspoding to present epe
425: CURSOR c_present_ecr (p_present_epe NUMBER)
426: IS
427: SELECT enrt_rt_id, mx_elcn_val max_val, mn_elcn_val min_val
428: FROM ben_enrt_rt
429: WHERE elig_per_elctbl_chc_id = p_present_epe
430: AND entr_val_at_enrt_flag = 'Y'
431: AND p_business_group_id = p_business_group_id;
432: