APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_EN_SU_ATTEMPT

Line 800: CURSOR cur_unit_audit(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

796: FROM igs_ps_usec_occurs_all uso
797: WHERE uso.uoo_id = cp_n_uoo_id
798: AND building_code IS NOT NULL;
799:
800: CURSOR cur_unit_audit(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
801: SELECT 'X'
802: FROM IGS_EN_SU_ATTEMPT
803: WHERE uoo_id = cp_uoo_id
804: AND no_assessment_ind='Y';

Line 802: FROM IGS_EN_SU_ATTEMPT

798: AND building_code IS NOT NULL;
799:
800: CURSOR cur_unit_audit(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
801: SELECT 'X'
802: FROM IGS_EN_SU_ATTEMPT
803: WHERE uoo_id = cp_uoo_id
804: AND no_assessment_ind='Y';
805: rec_unit_audit cur_unit_audit%ROWTYPE;
806:

Line 3009: CURSOR cur_is_audited(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

3005: WHERE uoo_id = cp_n_uoo_id;
3006:
3007: c_usec_lim_rec c_usec_lim%ROWTYPE;
3008: rec_act c_act%ROWTYPE;
3009: CURSOR cur_is_audited(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3010: SELECT count(*)
3011: FROM igs_en_su_attempt
3012: WHERE uoo_id = cp_uoo_id
3013: AND no_assessment_ind = 'Y';

Line 3011: FROM igs_en_su_attempt

3007: c_usec_lim_rec c_usec_lim%ROWTYPE;
3008: rec_act c_act%ROWTYPE;
3009: CURSOR cur_is_audited(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3010: SELECT count(*)
3011: FROM igs_en_su_attempt
3012: WHERE uoo_id = cp_uoo_id
3013: AND no_assessment_ind = 'Y';
3014:
3015: CURSOR cur_db_value(cp_uoo_id igs_ps_usec_lim_wlst.uoo_id%TYPE) IS