DBA Data[Home] [Help]

APPS.PN_VAR_RENT_CALC_PKG dependencies on FND_DATE

Line 6456: AND start_date <= NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'))

6452: end_date
6453: FROM pn_var_periods_all
6454: WHERE var_rent_id = ip_var_rent_id
6455: AND period_id = NVL(p_period_id,period_id)
6456: AND start_date <= NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'))
6457: AND period_num >= NVL(p_period_num_from,period_num)
6458: AND period_num <= NVL(p_period_num_to,period_num);
6459:
6460: