APPS.IGS_PR_ACAD_DETAILS dependencies on FND_DATE

Line 632: NVL(susa.end_dt, fnd_date.canonical_to_date('9999/12/31'))))

628: AND p_course_cd = susa.course_cd
629: AND (igs_en_gen_015.get_effective_census_date(
630: NULL, NULL, p_teach_cal_type, p_teach_ci_sequence_number)
631: BETWEEN susa.selection_dt AND NVL(susa.rqrmnts_complete_dt,
632: NVL(susa.end_dt, fnd_date.canonical_to_date('9999/12/31'))))
633: AND susa.unit_set_cd = us.unit_set_cd
634: AND us.unit_set_cat = usc.unit_set_cat
635: AND usc.s_unit_set_cat = 'PRENRL_YR'
636: ORDER BY susa.selection_dt DESC;