66: CP_ORGANIZATION := l_organization;
67:
68: CP_LEGAL_ENTITY := l_legal_entity;
69: begin
70: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
71: l_all := substrb(fnd_message.get,1,80);
72: select name into CP_PERSON_BNFT_GRP
73: from ben_benfts_grp a,
74: ben_benefit_actions b
67:
68: CP_LEGAL_ENTITY := l_legal_entity;
69: begin
70: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
71: l_all := substrb(fnd_message.get,1,80);
72: select name into CP_PERSON_BNFT_GRP
73: from ben_benfts_grp a,
74: ben_benefit_actions b
75: where a.benfts_grp_id = b.benfts_grp_id