APPS.IGS_AD_TRANSCRIPT_PKG dependencies on IGS_AD_TRANSCRIPT_V

Line 19: SELECT 'A' FROM IGS_AD_TRANSCRIPT_V TRANS WHERE EDUCATION_ID = cp_education_id

15: || Who When What
16: || (reverse chronological order - newest change first)
17: */
18: CURSOR check_issuedate(cp_education_id IN NUMBER,cp_date_of_issue IN DATE) IS
19: SELECT 'A' FROM IGS_AD_TRANSCRIPT_V TRANS WHERE EDUCATION_ID = cp_education_id
20: AND DATE_OF_ISSUE = cp_date_of_issue
21: AND (new_references.transcript_id IS NULL OR new_references.transcript_id <> trans.transcript_id);
22: l_temp VARCHAR2(1);
23: