APPS.IGS_PR_ACAD_DETAILS dependencies on IGS_EN_GEN_015

Line 629: AND (igs_en_gen_015.get_effective_census_date(

625: IGS_EN_UNIT_SET US,
626: IGS_EN_UNIT_SET_CAT USC
627: WHERE p_person_id = susa.person_id
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