DBA Data[Home] [Help]

APPS.GHR_BENEFITS_EIT dependencies on BEN_LEE_RSN_F

Line 1119: SELECT 1 from ben_lee_rsn_f r, ben_popl_enrt_typ_cycl_f p, fnd_sessions se

1115:
1116: CURSOR c_chk_le_exists(p_pgm_id in number,
1117: p_ler_id in number)
1118: is
1119: SELECT 1 from ben_lee_rsn_f r, ben_popl_enrt_typ_cycl_f p, fnd_sessions se
1120: WHERE se.session_id = userenv('sessionid')
1121: AND r.popl_enrt_typ_cycl_id = p.popl_enrt_typ_cycl_id
1122: AND r.business_group_id = p.business_group_id
1123: AND p.pgm_id = p_pgm_id