[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'