APPS.BEN_BENDESUM_XMLP_PKG dependencies on BEN_BENEFIT_ACTIONS

Line 92: ben_benefit_actions b

88: l_all := substrb(fnd_message.get,1,80);
89: begin
90: select name into CP_PERSON_BNFT_GRP
91: from ben_benfts_grp a,
92: ben_benefit_actions b
93: where a.benfts_grp_id = b.benfts_grp_id
94: and b.request_id = P_CONCURRENT_REQUEST_ID;
95:
96: exception when no_data_found then

Line 103: ben_benefit_actions b

99: end;
100: begin
101: select location_code into CP_LOCATION
102: from hr_locations a,
103: ben_benefit_actions b
104: where a.location_id = b.location_id
105: and b.request_id = P_CONCURRENT_REQUEST_ID;
106:
107: exception when no_data_found then

Line 136: ben_benefit_actions ba

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';
140: return 1;