DBA Data[Home] [Help]

APPS.IGS_AV_LVL_LGCY_PUB dependencies on IGS_AD_TERM_DETAILS

Line 1018: igs_ad_term_details td

1014: cp_person_id igs_pe_person.person_id%TYPE,
1015: cp_inst_cd igs_av_acad_history_v.institution_code%TYPE) IS
1016: SELECT ahv.unit_details_id
1017: FROM igs_av_acad_history_v ahv,
1018: igs_ad_term_details td
1019: WHERE ahv.term_details_id = td.term_details_id
1020: AND ahv.term=td.term
1021: AND td.term = cp_prev_term
1022: AND td.start_date = cp_start_date