DBA Data[Home] [Help]

APPS.BEN_CLS_UNRESOLVED_ACTN_ITEM dependencies on BEN_OIPL_F

Line 788: from ben_oipl_f oipl,

784:
785: cursor c_opt_info(c_oipl_id number)
786: is
787: select ':'||opt.name||'('||to_char(opt.opt_id )||')' name1
788: from ben_oipl_f oipl,
789: ben_opt_f opt
790: where oipl.oipl_id = c_oipl_id
791: and p_effective_date between oipl.effective_start_date
792: and oipl.effective_end_date