APPS.PN_VAR_RENT_CALC_PKG dependencies on FND_DATE

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

6494: end_date
6495: FROM pn_var_periods_all
6496: WHERE var_rent_id = ip_var_rent_id
6497: AND period_id = NVL(p_period_id,period_id)
6498: AND start_date <= NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'))
6499: AND period_num >= NVL(p_period_num_from,period_num)
6500: AND period_num <= NVL(p_period_num_to,period_num);
6501:
6502: