APPS.BEN_BENLESUM_XMLP_PKG dependencies on BEN_RPTG_GRP

Line 31: Select tl.name from ben_rptg_grp rpt,ben_rptg_grp_tl tl where rpt.rptg_grp_id=p_reporting_group_id and business_group_id=p_business_group_id and rpt.rptg_grp_id=tl.rptg_grp_id

27: cursor c_benefit_group_name is
28: Select name from BEN_BENFTS_GRP where benfts_grp_id=p_benefit_group_id and business_group_id=p_business_group_id;
29:
30: cursor c_reporting_group_name is
31: Select tl.name from ben_rptg_grp rpt,ben_rptg_grp_tl tl where rpt.rptg_grp_id=p_reporting_group_id and business_group_id=p_business_group_id and rpt.rptg_grp_id=tl.rptg_grp_id
32: and tl.language=userenv('LANG');
33:
34: cursor c_ler_name is
35: Select tl.name from ben_ler_f ler, ben_ler_f_tl tl

Line 205: cursor c_rpt_grp is Select tl.name from ben_rptg_grp rpt,ben_rptg_grp_tl tl

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
206: where rpt.rptg_grp_id=p_reporting_group_id and
207: business_group_id=p_business_group_id and rpt.rptg_grp_id=tl.rptg_grp_id
208: and tl.language=userenv('LANG');
209: