DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DPNT_ELIG_SS dependencies on BEN_PLIP_F

Line 676: from ben_plip_f plip

672: select plip.plip_id,
673: plip.pl_id,
674: plip.vrfy_fmly_mmbr_cd,
675: plip.vrfy_fmly_mmbr_rl
676: from ben_plip_f plip
677: where plip.business_group_id = p_business_group_id
678: and plip.plip_stat_cd = 'A'
679: and plip.pgm_id = l_pgm_id
680: and p_effective_date