APPS.OTA_TDB_BUS dependencies on FND_PROFILE

Line 2826: IF ( NVL(FND_PROFILE.VALUE('HR_LETTER_BY_VACANCY'), 'N') <> 'Y' ) THEN

2822: OPEN csr_get_business_group_id;
2823: FETCH csr_get_business_group_id INTO l_business_group_id;
2824: CLOSE csr_get_business_group_id;
2825:
2826: IF ( NVL(FND_PROFILE.VALUE('HR_LETTER_BY_VACANCY'), 'N') <> 'Y' ) THEN
2827: --
2828: OPEN c_letter_requests(p_booking_status_type_id);
2829: --
2830: FETCH c_letter_requests INTO l_letter_type_id,