DBA Data[Home] [Help]

APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on BEN_PL_F

Line 432: from ben_ptip_f ptip, ben_pl_f pl

428: (c_effective_date in date
429: )
430: is
431: select ptip.ptip_id
432: from ben_ptip_f ptip, ben_pl_f pl
433: where ptip.pl_typ_id = pl.pl_typ_id
434: and ptip.pgm_id = p_pgm_id
435: and pl.pl_id = p_pl_id
436: and c_effective_date

Line 594: from ben_pl_f pl

590: (c_effective_date in date
591: )
592: is
593: select pl.pl_typ_id
594: from ben_pl_f pl
595: where pl.pl_id = p_pl_id
596: and c_effective_date
597: between pl.effective_start_date
598: and pl.effective_end_date;