APPS.IGS_AD_TERM_UNITDTLS_PKG dependencies on IGS_AD_ACAD_HISTORY_V

Line 24: FROM igs_ad_acad_history_v hist, igs_ad_transcript_v trans, igs_ad_term_details_v term

20: ***************************************************************/
21:
22: CURSOR check_status(cp_term_details_id IN NUMBER) IS
23: SELECT DISTINCT 1
24: FROM igs_ad_acad_history_v hist, igs_ad_transcript_v trans, igs_ad_term_details_v term
25: WHERE hist.education_id = trans.education_id
26: AND trans.transcript_id = term.transcript_id
27: AND term.term_details_id = cp_term_details_id
28: AND hist.status = 'I';