DBA Data[Home] [Help]

APPS.BEN_CLS_UNRESOLVED_ACTN_ITEM dependencies on BEN_OPT_F

Line 789: ben_opt_f opt

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
793: and opt.opt_id = oipl.opt_id