DBA Data[Home] [Help]

APPS.FA_GAINLOSS_DPR_PKG dependencies on FA_CALENDAR_PERIODS

Line 351: from fa_calendar_periods

347: l_life_end_date := add_months(dpr.prorate_date,dpr.life);
348:
349: select end_date
350: into l_pcal_life_end_date
351: from fa_calendar_periods
352: where calendar_type = p_cal
353: and l_life_end_date between start_date and end_date;
354:
355: select end_date

Line 357: from fa_calendar_periods

353: and l_life_end_date between start_date and end_date;
354:
355: select end_date
356: into l_pcal_ret_end_date
357: from fa_calendar_periods
358: where calendar_type = p_cal
359: and to_date(dpr.ret_prorate_jdate,'j') between start_date and end_date;
360:
361: if (l_pcal_life_end_date <= l_pcal_ret_end_date) then