DBA Data[Home] [Help]

APPS.FA_REC_PVT_PKG3 dependencies on FA_CALENDAR_PERIODS

Line 303: FROM FA_CALENDAR_PERIODS cp, FA_BOOK_CONTROLS bc

299: WHERE conv.prorate_convention_code = p_new_conv
300: AND p_date_placed_in_service between conv.start_date and conv.end_date;
301: CURSOR check_prorate_date IS
302: SELECT 'x'
303: FROM FA_CALENDAR_PERIODS cp, FA_BOOK_CONTROLS bc
304: WHERE bc.book_type_code = p_book_type_code
305: AND bc.prorate_calendar = cp.calendar_type
306: AND l_prorate_date between cp.start_date and cp.end_date;
307: BEGIN