APPS.IGS_EN_GEN_012 dependencies on IGS_PS_VER

Line 909: FROM igs_en_stdnt_ps_att spa, igs_ps_ver pv1, igs_ps_ver pv2

905: sca.course_cd = cp_course_cd;
906:
907: CURSOR c_prgs_in_career IS
908: SELECT 'X'
909: FROM igs_en_stdnt_ps_att spa, igs_ps_ver pv1, igs_ps_ver pv2
910: WHERE spa.person_id = p_person_id
911: AND spa.course_cd = p_transf_course_cd -- dest course cd
912: AND pv1.course_cd = spa.course_cd
913: AND pv1.version_number = spa.version_number

Line 1646: IGS_PS_VER crv

1642: CURSOR c_sca_crv IS
1643: SELECT sca.person_id,
1644: sca.course_cd
1645: FROM IGS_EN_STDNT_PS_ATT sca,
1646: IGS_PS_VER crv
1647: WHERE sca.cal_type = p_acad_cal_type AND
1648: sca.course_cd LIKE p_course_cd AND
1649: sca.course_attempt_status = cst_inactive AND
1650: crv.course_cd = sca.course_cd AND

Line 2524: cp_course_cd igs_ps_ver.course_cd%TYPE,

2520: sca.course_attempt_status NOT IN ('DISCONTIN',
2521: 'DELETED');
2522: -- smaddali added cursor for build EN324 - bug#5091858
2523: CURSOR c_sci_rcond (cp_person_id hz_parties.party_id%TYPE,
2524: cp_course_cd igs_ps_ver.course_cd%TYPE,
2525: cp_start_dt DATE,
2526: cp_logical_del_dt DATE) IS
2527: SELECT hz.party_number
2528: FROM igs_en_spi_rconds rc, hz_parties hz