eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_EN_VAL_SCA dependencies on IGS_CA_INST_REL

Line 246: FROM IGS_CA_INST_REL cir,

242: CURSOR c_cir_cat_daiv_srcc IS
243: SELECT daiv.alias_val,
244: daiv.cal_type,
245: daiv.ci_sequence_number
246: FROM IGS_CA_INST_REL cir,
247: IGS_CA_TYPE cat,
248: IGS_CA_DA_INST_V daiv,
249: IGS_RE_S_RES_CAL_CON srcc
250: WHERE cir.sub_cal_type = v_adm_cal_type AND

Line 262: FROM IGS_CA_INST_REL cir,

258: ORDER BY daiv.alias_val ASC;
259: v_ccds_exists VARCHAR2(1);
260: CURSOR c_cir_cat_daiv_sgcc IS
261: SELECT 'x'
262: FROM IGS_CA_INST_REL cir,
263: IGS_CA_TYPE cat,
264: IGS_CA_DA_INST_V daiv,
265: IGS_GE_S_GEN_CAL_CON sgcc
266: WHERE cir.sub_cal_type = v_adm_cal_type AND

Line 391: v_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;

387: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
388: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
389: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
390: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
391: v_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
392: v_load_ci_sequence_number
393: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
394: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
395: v_acad_ci_sequence_number

Line 393: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;

389: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
390: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
391: v_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
392: v_load_ci_sequence_number
393: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
394: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
395: v_acad_ci_sequence_number
396: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
397: v_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;

Line 394: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;

390: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
391: v_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
392: v_load_ci_sequence_number
393: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
394: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
395: v_acad_ci_sequence_number
396: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
397: v_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
398: v_research_eftsu NUMBER;

Line 396: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;

392: v_load_ci_sequence_number
393: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
394: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
395: v_acad_ci_sequence_number
396: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
397: v_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE;
398: v_research_eftsu NUMBER;
399: v_lower_enr_load_range IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
400: v_upper_enr_load_range IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;

Line 417: IGS_CA_INST_REL cir,

413: SELECT cir.sup_cal_type,
414: cir.sup_ci_sequence_number,
415: sua.cal_type
416: FROM IGS_EN_SU_ATTEMPT sua,
417: IGS_CA_INST_REL cir,
418: IGS_CA_INST ci,
419: IGS_CA_TYPE cat,
420: IGS_PS_UNIT_VER uv
421: WHERE sua.person_id = p_person_id AND

Line 435: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

431: sua.ci_sequence_number = cir.sub_ci_sequence_number AND
432: cir.sup_cal_type = cat.cal_type AND
433: cat.s_cal_cat = cst_academic;
434: CURSOR c_cir (
435: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
436: cp_acad_ci_sequence_number
437: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE,
438: cp_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE) IS
439: SELECT dla.cal_type,

Line 437: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE,

433: cat.s_cal_cat = cst_academic;
434: CURSOR c_cir (
435: cp_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
436: cp_acad_ci_sequence_number
437: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE,
438: cp_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE) IS
439: SELECT dla.cal_type,
440: dla.ci_sequence_number
441: FROM IGS_CA_INST_REL cir,

Line 441: FROM IGS_CA_INST_REL cir,

437: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE,
438: cp_teach_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE) IS
439: SELECT dla.cal_type,
440: dla.ci_sequence_number
441: FROM IGS_CA_INST_REL cir,
442: IGS_ST_DFT_LOAD_APPO dla
443: WHERE cir.sup_cal_type = cp_acad_cal_type AND
444: cir.sup_ci_sequence_number = cp_acad_ci_sequence_number AND
445: cir.sub_cal_type = dla.cal_type AND

Line 450: cp_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

446: cir.sub_ci_sequence_number = dla.ci_sequence_number AND
447: dla.teach_cal_type = cp_teach_cal_type AND
448: dla.percentage = 100;
449: CURSOR c_atl (
450: cp_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
451: cp_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE) IS
452: SELECT atl.lower_enr_load_range,
453: atl.upper_enr_load_range
454: FROM IGS_EN_ATD_TYPE_LOAD atl

Line 1495: FROM IGS_CA_INST_REL CIR,

1491: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)IS
1492: SELECT CI.cal_type,
1493: CI.sequence_number,
1494: CI.start_dt
1495: FROM IGS_CA_INST_REL CIR,
1496: IGS_CA_INST CI,
1497: IGS_CA_TYPE CT,
1498: IGS_CA_STAT CS
1499: WHERE CT.closed_ind = 'N' AND