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_GEN_015 dependencies on IGS_CA_TYPE

Line 1257: FROM igs_ca_type ct,

1253: SELECT ci.cal_type,
1254: ci.sequence_number,
1255: ci.start_dt,
1256: ci.end_dt
1257: FROM igs_ca_type ct,
1258: igs_ca_inst ci,
1259: igs_ca_stat cs,
1260: igs_ca_inst_rel cir
1261: WHERE ct.closed_ind = 'N'

Line 1271: igs_ca_type ct

1267: AND cir.sub_ci_sequence_number =ci.sequence_number
1268: AND cir.sup_cal_type = cp_cal_type
1269: AND cir.sup_ci_sequence_number = cp_sequence_number
1270: AND EXISTS ( SELECT 1 FROM igs_ca_inst_rel cir,
1271: igs_ca_type ct
1272: WHERE cir.sup_cal_type = cp_cal_type
1273: AND cir.sup_ci_sequence_number = cp_sequence_number
1274: AND cir.sub_cal_type = ci.cal_type
1275: AND cir.sub_ci_sequence_number = ci.sequence_number

Line 1501: CURSOR cur_load_dtl_of_uoo_id (p_cal_type IGS_CA_TYPE.cal_type%TYPE , p_ci_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS

1497: FROM IGS_PS_UNIT_OFR_OPT
1498: WHERE uoo_id = p_uoo_id;
1499:
1500: -- Cursor to get the Load Calendar of the given Teach Calendar.
1501: CURSOR cur_load_dtl_of_uoo_id (p_cal_type IGS_CA_TYPE.cal_type%TYPE , p_ci_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS
1502: SELECT load_cal_type,
1503: load_ci_sequence_number
1504: FROM igs_ca_teach_to_load_v
1505: WHERE teach_cal_type = p_cal_type

Line 2037: l_enrol_cal_type igs_ca_type.cal_type%TYPE;

2033: l_teach_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
2034: l_commencement_type igs_en_cat_prc_dtl.S_STUDENT_COMM_TYPE%TYPE;
2035: l_enr_method IGS_EN_METHOD_TYPE.enr_method_type%TYPE;
2036: l_enrollment_category igs_en_cat_prc_dtl.enrolment_cat%TYPE;
2037: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
2038: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2039: l_system_type igs_pe_person_types.system_type%TYPE;
2040: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2041: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 2720: FROM igs_ca_type ct,

2716: ci.sequence_number,
2717: ci.alternate_code,
2718: ci.start_dt,
2719: ci.end_dt
2720: FROM igs_ca_type ct,
2721: igs_ca_inst ci,
2722: igs_ca_stat cs,
2723: igs_ca_inst_rel cir
2724: WHERE cs.s_cal_status = cst_active

Line 2899: FROM igs_ca_type ct,

2895: ci.sequence_number,
2896: ci.alternate_code,
2897: ci.start_dt,
2898: ci.end_dt
2899: FROM igs_ca_type ct,
2900: igs_ca_inst ci,
2901: igs_ca_stat cs,
2902: igs_ca_inst_rel cir
2903: WHERE cs.s_cal_status = cst_active

Line 2933: FROM igs_ca_type ct,

2929: ci.sequence_number,
2930: ci.alternate_code,
2931: ci.start_dt,
2932: ci.end_dt
2933: FROM igs_ca_type ct,
2934: igs_ca_inst ci,
2935: igs_ca_stat cs,
2936: igs_ca_inst_rel cir
2937: WHERE cs.s_cal_status = cst_active

Line 3125: FROM igs_ca_type ct,

3121: SELECT ci.cal_type,
3122: ci.sequence_number,
3123: ci.start_dt,
3124: ci.end_dt
3125: FROM igs_ca_type ct,
3126: igs_ca_inst ci,
3127: igs_ca_stat cs,
3128: igs_ca_inst_rel cir
3129: WHERE ct.closed_ind = 'N'

Line 3139: igs_ca_type ct

3135: AND cir.sub_ci_sequence_number =ci.sequence_number
3136: AND cir.sup_cal_type = cp_cal_type
3137: AND cir.sup_ci_sequence_number = cp_sequence_number
3138: AND EXISTS ( SELECT 1 FROM igs_ca_inst_rel cir,
3139: igs_ca_type ct
3140: WHERE cir.sup_cal_type = cp_cal_type
3141: AND cir.sup_ci_sequence_number = cp_sequence_number
3142: AND cir.sub_cal_type = ci.cal_type
3143: AND cir.sub_ci_sequence_number = ci.sequence_number