APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_COM_INST

Line 2544: CURSOR validate_Institution (p_inst igs_uc_com_inst.inst%TYPE) IS

2540: WHERE app_no = p_appno;
2541:
2542:
2543: -- validate institution value
2544: CURSOR validate_Institution (p_inst igs_uc_com_inst.inst%TYPE) IS
2545: SELECT 'X'
2546: FROM igs_uc_com_inst
2547: WHERE inst = p_inst;
2548:

Line 2546: FROM igs_uc_com_inst

2542:
2543: -- validate institution value
2544: CURSOR validate_Institution (p_inst igs_uc_com_inst.inst%TYPE) IS
2545: SELECT 'X'
2546: FROM igs_uc_com_inst
2547: WHERE inst = p_inst;
2548:
2549: -- get entry year from UCAS Control.
2550: CURSOR get_control_entry_year (p_system igs_uc_applicants.system_code%TYPE, p_cycle igs_uc_istarc_ints.ucas_cycle%TYPE) IS

Line 3281: CURSOR validate_Institution (p_inst igs_uc_com_inst.inst%TYPE) IS

3277: WHERE app_no = p_appno;
3278:
3279:
3280: -- validate institution value
3281: CURSOR validate_Institution (p_inst igs_uc_com_inst.inst%TYPE) IS
3282: SELECT 'X'
3283: FROM igs_uc_com_inst
3284: WHERE inst = p_inst;
3285:

Line 3283: FROM igs_uc_com_inst

3279:
3280: -- validate institution value
3281: CURSOR validate_Institution (p_inst igs_uc_com_inst.inst%TYPE) IS
3282: SELECT 'X'
3283: FROM igs_uc_com_inst
3284: WHERE inst = p_inst;
3285:
3286: -- get entry year from UCAS Control.
3287: CURSOR get_control_entry_year (p_system igs_uc_applicants.system_code%TYPE, p_cycle igs_uc_istarg_ints.ucas_cycle%TYPE) IS

Line 5714: FROM igs_uc_com_inst

5710:
5711: -- validate Institution value
5712: CURSOR validate_inst (p_inst igs_uc_app_clearing.institution%TYPE) IS
5713: SELECT ucas, gttr, nmas, swas
5714: FROM igs_uc_com_inst
5715: WHERE inst = p_inst;
5716:
5717: -- validate Course value
5718: CURSOR validate_Course (p_course igs_uc_istarz1_ints.course%TYPE,

Line 6301: FROM igs_uc_com_inst

6297:
6298: -- validate Institution value
6299: CURSOR validate_inst (p_inst igs_uc_app_clearing.institution%TYPE) IS
6300: SELECT ucas, gttr, nmas, swas
6301: FROM igs_uc_com_inst
6302: WHERE inst = p_inst;
6303:
6304:
6305: -- validate Course value/get OSS Program details