APPS.IGS_EN_VAL_SUA dependencies on IGS_PS_OFR_OPT

Line 3077: FROM IGS_PS_OFR_OPT

3073: v_other_detail VARCHAR(255);
3074: CURSOR c_coo(
3075: cp_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE) IS
3076: SELECT *
3077: FROM IGS_PS_OFR_OPT
3078: WHERE IGS_PS_OFR_OPT.coo_id = cp_coo_id
3079: AND IGS_PS_OFR_OPT.delete_flag = 'N';
3080: BEGIN
3081: -- This module validates the nominated unit location code against

Line 3078: WHERE IGS_PS_OFR_OPT.coo_id = cp_coo_id

3074: CURSOR c_coo(
3075: cp_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE) IS
3076: SELECT *
3077: FROM IGS_PS_OFR_OPT
3078: WHERE IGS_PS_OFR_OPT.coo_id = cp_coo_id
3079: AND IGS_PS_OFR_OPT.delete_flag = 'N';
3080: BEGIN
3081: -- This module validates the nominated unit location code against
3082: -- course_offering_option location code for the enrolled course

Line 3079: AND IGS_PS_OFR_OPT.delete_flag = 'N';

3075: cp_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE) IS
3076: SELECT *
3077: FROM IGS_PS_OFR_OPT
3078: WHERE IGS_PS_OFR_OPT.coo_id = cp_coo_id
3079: AND IGS_PS_OFR_OPT.delete_flag = 'N';
3080: BEGIN
3081: -- This module validates the nominated unit location code against
3082: -- course_offering_option location code for the enrolled course
3083: p_message_name := null;

Line 3117: FROM IGS_PS_OFR_OPT

3113: v_other_detail VARCHAR(255);
3114: CURSOR c_coo(
3115: cp_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE) IS
3116: SELECT *
3117: FROM IGS_PS_OFR_OPT
3118: WHERE IGS_PS_OFR_OPT.coo_id = cp_coo_id
3119: AND IGS_PS_OFR_OPT.delete_flag = 'N';
3120: CURSOR c_unit_class(
3121: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS

Line 3118: WHERE IGS_PS_OFR_OPT.coo_id = cp_coo_id

3114: CURSOR c_coo(
3115: cp_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE) IS
3116: SELECT *
3117: FROM IGS_PS_OFR_OPT
3118: WHERE IGS_PS_OFR_OPT.coo_id = cp_coo_id
3119: AND IGS_PS_OFR_OPT.delete_flag = 'N';
3120: CURSOR c_unit_class(
3121: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
3122: SELECT unit_mode

Line 3119: AND IGS_PS_OFR_OPT.delete_flag = 'N';

3115: cp_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE) IS
3116: SELECT *
3117: FROM IGS_PS_OFR_OPT
3118: WHERE IGS_PS_OFR_OPT.coo_id = cp_coo_id
3119: AND IGS_PS_OFR_OPT.delete_flag = 'N';
3120: CURSOR c_unit_class(
3121: cp_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE) IS
3122: SELECT unit_mode
3123: FROM IGS_AS_UNIT_CLASS