1622: and p_effective_date between asg.effective_start_date
1623: and asg.effective_end_date;
1624: exception
1625: when no_data_found then
1626: fnd_message.set_name('BEN','BEN_92409_ASG_NOT_FOUND');
1627: fnd_message.set_token('PROC',l_proc);
1628: fnd_message.raise_error;
1629: end;
1630: --- check for whether the Business group allows
1623: and asg.effective_end_date;
1624: exception
1625: when no_data_found then
1626: fnd_message.set_name('BEN','BEN_92409_ASG_NOT_FOUND');
1627: fnd_message.set_token('PROC',l_proc);
1628: fnd_message.raise_error;
1629: end;
1630: --- check for whether the Business group allows
1631: --- creation of benefits assignments
1624: exception
1625: when no_data_found then
1626: fnd_message.set_name('BEN','BEN_92409_ASG_NOT_FOUND');
1627: fnd_message.set_token('PROC',l_proc);
1628: fnd_message.raise_error;
1629: end;
1630: --- check for whether the Business group allows
1631: --- creation of benefits assignments
1632: ---