DBA Data[Home] [Help]

APPS.BEN_BENDESUM_XMLP_PKG dependencies on BEN_REPORTING

Line 135: from ben_reporting rpt,

131: CP_DEFWCHG := nvl(CP_DEFWCHG,0);
132: CP_DEFTOTAL := CP_DEFNOCHG + CP_DEFWCHG;
133: select count(distinct related_person_id)
134: into CP_PARTICIPANTS_ENDED
135: from ben_reporting rpt,
136: ben_benefit_actions ba
137: where ba.request_id=P_CONCURRENT_REQUEST_ID and
138: ba.benefit_action_id=rpt.benefit_action_id and
139: rpt.rep_typ_cd='DSGENDED';