APPS.BEN_BENLESUM_XMLP_PKG dependencies on BEN_BENFTS_GRP

Line 28: Select name from BEN_BENFTS_GRP where benfts_grp_id=p_benefit_group_id and business_group_id=p_business_group_id;

24: cursor c_BG_info is
25: select hr_general.decode_organization(p_organization_id),hr_general.decode_location(p_location_id),hr_general.decode_organization(p_business_group_id) from dual;
26:
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');