APPS.IGS_EN_SU_ATTEMPT_PKG dependencies on IGS_PS_VER

Line 2530: FROM igs_en_spa_terms spat, igs_en_stdnt_ps_att curspa, igs_ps_ver curcv,

2526:
2527: CURSOR c_term (p_person_id number, p_course_cd varchar2,
2528: p_term_cal_type varchar2, p_term_ci_sequence_number number) IS
2529: SELECT 'x'
2530: FROM igs_en_spa_terms spat, igs_en_stdnt_ps_att curspa, igs_ps_ver curcv,
2531: igs_en_stdnt_ps_att spa, igs_ps_ver cv
2532: WHERE spat.person_id = p_person_id
2533: AND term_cal_type = p_term_cal_type AND term_sequence_number = p_term_ci_sequence_number
2534: AND curspa.person_id=spat.person_id AND curspa.course_cd=p_course_Cd

Line 2531: igs_en_stdnt_ps_att spa, igs_ps_ver cv

2527: CURSOR c_term (p_person_id number, p_course_cd varchar2,
2528: p_term_cal_type varchar2, p_term_ci_sequence_number number) IS
2529: SELECT 'x'
2530: FROM igs_en_spa_terms spat, igs_en_stdnt_ps_att curspa, igs_ps_ver curcv,
2531: igs_en_stdnt_ps_att spa, igs_ps_ver cv
2532: WHERE spat.person_id = p_person_id
2533: AND term_cal_type = p_term_cal_type AND term_sequence_number = p_term_ci_sequence_number
2534: AND curspa.person_id=spat.person_id AND curspa.course_cd=p_course_Cd
2535: AND curcv.course_Cd=curspa.course_cd AND curcv.version_number=curspa.version_number

Line 2555: cp_program_cd IGS_PS_VER.COURSE_CD%TYPE,

2551:
2552: CURSOR c_other_key_recs ( cp_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE,
2553: cp_term_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2554: cp_term_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
2555: cp_program_cd IGS_PS_VER.COURSE_CD%TYPE,
2556: cp_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE) IS
2557: SELECT 'X'
2558: FROM IGS_EN_SPA_TERMS
2559: WHERE person_id = cp_person_id