DBA Data[Home] [Help]

APPS.BEN_CLS_UNRESOLVED_ACTN_ITEM dependencies on BEN_PL_F

Line 780: from ben_pl_f pl

776: and pgm.effective_end_date;
777: cursor c_pl_info(c_pl_id number)
778: is
779: select pl.name||'('||to_char(pl.pl_id)||')' name1
780: from ben_pl_f pl
781: where pl.pl_id = c_pl_id
782: and p_effective_date between pl.effective_start_date
783: and pl.effective_end_date;
784: