DBA Data[Home] [Help]

APPS.FA_GAINLOSS_DPR_PKG dependencies on FA_CALENDAR_PERIODS

Line 398: from fa_calendar_periods

394: l_life_end_date := add_months(dpr.prorate_date,dpr.life);
395:
396: select end_date
397: into l_pcal_life_end_date
398: from fa_calendar_periods
399: where calendar_type = p_cal
400: and l_life_end_date between start_date and end_date;
401:
402: select end_date

Line 404: from fa_calendar_periods

400: and l_life_end_date between start_date and end_date;
401:
402: select end_date
403: into l_pcal_ret_end_date
404: from fa_calendar_periods
405: where calendar_type = p_cal
406: and to_date(dpr.ret_prorate_jdate,'j') between start_date and end_date;
407:
408: if (l_pcal_life_end_date <= l_pcal_ret_end_date) then