390: p_effective_date IN DATE) RETURN VARCHAR2
391: IS
392: Cursor csr_assignment_exist_for_acco IS
393: SELECT 'Y' 394: FROM DUAL 395: WHERE EXISTS( Select NULL
396: from pqh_assign_accommodations_f
397: where accommodation_id = p_accommodation_id
398: and trunc(p_effective_date) between effective_start_date and effective_end_date