DBA Data[Home] [Help]

APPS.BEN_PER_ASG_ELIG dependencies on BEN_ELIG_OBJ_ELIG_PROFL_F

Line 55: from ben_elig_obj_elig_profl_f

51: select elig_prfl_id,
52: nvl(mndtry_flag,'N'),
53: 'Y',
54: 'N'
55: from ben_elig_obj_elig_profl_f
56: where elig_obj_id = p_elig_obj_id
57: and p_effective_date between effective_start_date
58: and effective_end_date
59: order by decode(mndtry_flag,'Y',1,2);