Line 398: if (nvl(fnd_profile.value('HR_LETTER_BY_VACANCY'),'N')='Y') then
394: return;
395: end if;
396: close csr_check_manual_or_auto;
397: 398: if (nvl(fnd_profile.value('HR_LETTER_BY_VACANCY'),'N')='Y') then 399:
400: hr_utility.set_location('HR_LETTER_BY_VACANCY = Y',10);
401: insert into per_letter_requests
402: ( letter_request_id