DBA Data[Home] [Help]

APPS.BEN_BENLESUM_XMLP_PKG dependencies on BEN_POPL_RPTG_GRP_F

Line 201: cursor c_pl is select null from ben_popl_rptg_grp_f rgr

197: if (p_pl_id is not null and p_reporting_group_id is not null) then
198: declare
199: l_dummy varchar2(1);
200: l_rpt_grp_name varchar2(300):=null;
201: cursor c_pl is select null from ben_popl_rptg_grp_f rgr
202: where rgr.rptg_grp_id = p_reporting_group_id
203: and rgr.pl_id=p_pl_id
204: and p_run_date between rgr.effective_start_date and rgr.effective_end_date;
205: cursor c_rpt_grp is Select tl.name from ben_rptg_grp rpt,ben_rptg_grp_tl tl