DBA Data[Home] [Help]

APPS.FA_REC_PVT_PKG3 dependencies on FA_CALENDAR_PERIODS

Line 317: FROM FA_CALENDAR_PERIODS cp, FA_BOOK_CONTROLS bc

313: WHERE conv.prorate_convention_code = p_new_conv
314: AND p_date_placed_in_service between conv.start_date and conv.end_date;
315: CURSOR check_prorate_date IS
316: SELECT 'x'
317: FROM FA_CALENDAR_PERIODS cp, FA_BOOK_CONTROLS bc
318: WHERE bc.book_type_code = p_book_type_code
319: AND bc.prorate_calendar = cp.calendar_type
320: AND l_prorate_date between cp.start_date and cp.end_date;
321: BEGIN