31: l_all varchar2(80);
32:
33: cursor c_benefit_action_id is
34: select benefit_action_id
35: from ben_benefit_actions
36: where request_id = P_CONCURRENT_REQUEST_ID;
37:
38: begin
39:
88: l_all := substrb(fnd_message.get,1,80);
89: begin
90: select name into CP_BENEFIT_GROUP
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
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