DBA Data[Home] [Help]

APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on BEN_PL_F

Line 425: from ben_ptip_f ptip, ben_pl_f pl

421: (c_effective_date in date
422: )
423: is
424: select ptip.ptip_id
425: from ben_ptip_f ptip, ben_pl_f pl
426: where ptip.pl_typ_id = pl.pl_typ_id
427: and ptip.pgm_id = p_pgm_id
428: and pl.pl_id = p_pl_id
429: and c_effective_date

Line 586: from ben_pl_f pl

582: (c_effective_date in date
583: )
584: is
585: select pl.pl_typ_id
586: from ben_pl_f pl
587: where pl.pl_id = p_pl_id
588: and c_effective_date
589: between pl.effective_start_date
590: and pl.effective_end_date;