DBA Data[Home] [Help]

APPS.FA_REC_PVT_PKG3 dependencies on FA_CONVENTIONS

Line 312: FROM FA_CONVENTIONS conv

308: l_prorate_date DATE;
309: check_flag VARCHAR2(3);
310: CURSOR get_prorate_date IS
311: SELECT conv.prorate_date
312: FROM FA_CONVENTIONS conv
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'