DBA Data[Home] [Help]

APPS.PQH_FR_UTILITY dependencies on PQH_ASSIGN_ACCOMMODATIONS_F

Line 396: from pqh_assign_accommodations_f

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
399: and accommodation_given ='Y');
400: