1302: l_prof_val := fnd_profile.VALUE (
1303: NAME => 'ICX_PREFERRED_CURRENCY' );
1304:
1305: else -- Approver found, fetch profile value for the user.
1306: select user_id into l_approver_id from fnd_user where user_name = l_approver;
1307: l_prof_val := fnd_profile.VALUE_SPECIFIC(
1308: NAME => 'ICX_PREFERRED_CURRENCY',
1309: USER_ID => l_approver_id );
1310: end if;