196: fetch C_VAL into X_PARENT_HIERARCHY_ID;
197:
198: If C_VAL%NOTFOUND then
199: close C_VAL;
200: fnd_message.set_name( 'PER','PER_449916_HRC_PARNT_ID_ABSNT');
201: fnd_message.raise_error;
202: End If;
203:
204: close C_VAL;
197:
198: If C_VAL%NOTFOUND then
199: close C_VAL;
200: fnd_message.set_name( 'PER','PER_449916_HRC_PARNT_ID_ABSNT');
201: fnd_message.raise_error;
202: End If;
203:
204: close C_VAL;
205: end if;