DBA Data[Home] [Help]

APPS.FA_REC_PVT_PKG3 dependencies on FA_CONVENTIONS

Line 298: FROM FA_CONVENTIONS conv

294: l_prorate_date DATE;
295: check_flag VARCHAR2(3);
296: CURSOR get_prorate_date IS
297: SELECT conv.prorate_date
298: FROM FA_CONVENTIONS conv
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'