DBA Data[Home] [Help]

APPS.IGS_AV_LVL_LGCY_PUB dependencies on IGS_AV_ACAD_HISTORY_V

Line 1015: cp_inst_cd igs_av_acad_history_v.institution_code%TYPE) IS

1011: cp_prev_term igs_av_lgcy_lvl_int.prev_term%TYPE,
1012: cp_start_date igs_av_lgcy_lvl_int.start_date%TYPE,
1013: cp_end_date igs_av_lgcy_lvl_int.end_date%TYPE,
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

Line 1017: FROM igs_av_acad_history_v ahv,

1013: cp_end_date igs_av_lgcy_lvl_int.end_date%TYPE,
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