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_RU_GEN_001 dependencies on IGS_CA_INST

Line 2797: FROM IGS_PS_UNIT_OFR_OPT A, igs_ca_inst ci

2793: FOR cur_ec IN (
2794: SELECT a.cal_type,
2795: a.ci_sequence_number,
2796: ci.start_dt
2797: FROM IGS_PS_UNIT_OFR_OPT A, igs_ca_inst ci
2798: WHERE a.unit_cd = asu.unit_cd
2799: AND a.version_number = asu.version_number
2800: AND a.cal_type = ci.cal_type
2801: AND a.ci_sequence_number = ci.sequence_number

Line 4169: igs_ca_inst_rel cir,

4165: sua.cal_type,
4166: sua.ci_sequence_number,
4167: sua.uoo_id
4168: FROM igs_en_su_attempt sua,
4169: igs_ca_inst_rel cir,
4170: igs_ca_type cat,
4171: igs_ca_inst ci1,
4172: igs_ca_inst ci2
4173: WHERE sua.person_id = p_person_id

Line 4171: igs_ca_inst ci1,

4167: sua.uoo_id
4168: FROM igs_en_su_attempt sua,
4169: igs_ca_inst_rel cir,
4170: igs_ca_type cat,
4171: igs_ca_inst ci1,
4172: igs_ca_inst ci2
4173: WHERE sua.person_id = p_person_id
4174: AND sua.course_cd = p_course_cd
4175: AND sua.cal_type = cir.sub_cal_type

Line 4172: igs_ca_inst ci2

4168: FROM igs_en_su_attempt sua,
4169: igs_ca_inst_rel cir,
4170: igs_ca_type cat,
4171: igs_ca_inst ci1,
4172: igs_ca_inst ci2
4173: WHERE sua.person_id = p_person_id
4174: AND sua.course_cd = p_course_cd
4175: AND sua.cal_type = cir.sub_cal_type
4176: AND sua.ci_sequence_number = cir.sub_ci_sequence_number

Line 4307: CURSOR c_cir (cp_prg_cal_type igs_ca_inst.cal_type%TYPE,

4303: -- kdande 11-Nov-2002 Created the function as part of Progression Rules
4304: -- Enhancement for Financial Aid for Jan 2003 Release
4305: ------------------------------------------------------------------------------
4306: --Cursor to fetch the Load calendar corresponding to the Progression Calendar.
4307: CURSOR c_cir (cp_prg_cal_type igs_ca_inst.cal_type%TYPE,
4308: cp_prg_sequence_number igs_ca_inst.sequence_number%TYPE) IS
4309: SELECT cir.sub_cal_type cal_type, cir.sub_ci_sequence_number ci_sequence_number
4310: FROM IGS_CA_INST ci ,
4311: IGS_CA_INST_REL cir,

Line 4308: cp_prg_sequence_number igs_ca_inst.sequence_number%TYPE) IS

4304: -- Enhancement for Financial Aid for Jan 2003 Release
4305: ------------------------------------------------------------------------------
4306: --Cursor to fetch the Load calendar corresponding to the Progression Calendar.
4307: CURSOR c_cir (cp_prg_cal_type igs_ca_inst.cal_type%TYPE,
4308: cp_prg_sequence_number igs_ca_inst.sequence_number%TYPE) IS
4309: SELECT cir.sub_cal_type cal_type, cir.sub_ci_sequence_number ci_sequence_number
4310: FROM IGS_CA_INST ci ,
4311: IGS_CA_INST_REL cir,
4312: IGS_CA_TYPE cat,

Line 4310: FROM IGS_CA_INST ci ,

4306: --Cursor to fetch the Load calendar corresponding to the Progression Calendar.
4307: CURSOR c_cir (cp_prg_cal_type igs_ca_inst.cal_type%TYPE,
4308: cp_prg_sequence_number igs_ca_inst.sequence_number%TYPE) IS
4309: SELECT cir.sub_cal_type cal_type, cir.sub_ci_sequence_number ci_sequence_number
4310: FROM IGS_CA_INST ci ,
4311: IGS_CA_INST_REL cir,
4312: IGS_CA_TYPE cat,
4313: IGS_CA_STAT cs
4314: WHERE cir.sup_cal_type = cp_prg_cal_type

Line 4311: IGS_CA_INST_REL cir,

4307: CURSOR c_cir (cp_prg_cal_type igs_ca_inst.cal_type%TYPE,
4308: cp_prg_sequence_number igs_ca_inst.sequence_number%TYPE) IS
4309: SELECT cir.sub_cal_type cal_type, cir.sub_ci_sequence_number ci_sequence_number
4310: FROM IGS_CA_INST ci ,
4311: IGS_CA_INST_REL cir,
4312: IGS_CA_TYPE cat,
4313: IGS_CA_STAT cs
4314: WHERE cir.sup_cal_type = cp_prg_cal_type
4315: AND cir.sup_ci_sequence_number = cp_prg_sequence_number

Line 4686: igs_ca_inst ci_cur,

4682: sua.ci_sequence_number,
4683: sua.unit_attempt_status,
4684: uoo_id
4685: FROM igs_en_su_attempt sua,
4686: igs_ca_inst ci_cur,
4687: igs_ca_inst_rel cir,
4688: igs_ca_inst ci,
4689: igs_ca_type ct
4690: WHERE sua.person_id = p_person_id

Line 4687: igs_ca_inst_rel cir,

4683: sua.unit_attempt_status,
4684: uoo_id
4685: FROM igs_en_su_attempt sua,
4686: igs_ca_inst ci_cur,
4687: igs_ca_inst_rel cir,
4688: igs_ca_inst ci,
4689: igs_ca_type ct
4690: WHERE sua.person_id = p_person_id
4691: AND sua.course_cd = p_course_cd

Line 4688: igs_ca_inst ci,

4684: uoo_id
4685: FROM igs_en_su_attempt sua,
4686: igs_ca_inst ci_cur,
4687: igs_ca_inst_rel cir,
4688: igs_ca_inst ci,
4689: igs_ca_type ct
4690: WHERE sua.person_id = p_person_id
4691: AND sua.course_cd = p_course_cd
4692: AND sua.unit_attempt_status = 'COMPLETED'

Line 4713: igs_ca_inst_rel cir

4709: sua.ci_sequence_number,
4710: sua.unit_attempt_status,
4711: uoo_id
4712: FROM igs_en_su_attempt sua,
4713: igs_ca_inst_rel cir
4714: WHERE sua.person_id = p_person_id
4715: AND sua.course_cd = p_course_cd
4716: AND sua.unit_attempt_status = 'COMPLETED'
4717: AND sua.cal_type = cir.sub_cal_type

Line 4965: igs_ca_inst ci_cur,

4961: sua.cal_type,
4962: sua.ci_sequence_number,
4963: sua.uoo_id
4964: FROM igs_en_su_attempt sua,
4965: igs_ca_inst ci_cur,
4966: igs_ca_inst_rel cir,
4967: igs_ca_inst ci,
4968: igs_ca_type ct
4969: WHERE sua.person_id = p_person_id

Line 4966: igs_ca_inst_rel cir,

4962: sua.ci_sequence_number,
4963: sua.uoo_id
4964: FROM igs_en_su_attempt sua,
4965: igs_ca_inst ci_cur,
4966: igs_ca_inst_rel cir,
4967: igs_ca_inst ci,
4968: igs_ca_type ct
4969: WHERE sua.person_id = p_person_id
4970: AND sua.course_cd = p_course_cd

Line 4967: igs_ca_inst ci,

4963: sua.uoo_id
4964: FROM igs_en_su_attempt sua,
4965: igs_ca_inst ci_cur,
4966: igs_ca_inst_rel cir,
4967: igs_ca_inst ci,
4968: igs_ca_type ct
4969: WHERE sua.person_id = p_person_id
4970: AND sua.course_cd = p_course_cd
4971: AND sua.unit_attempt_status = 'COMPLETED'

Line 4989: igs_ca_inst_rel cir

4985: sua.cal_type,
4986: sua.ci_sequence_number,
4987: sua.uoo_id
4988: FROM igs_en_su_attempt sua,
4989: igs_ca_inst_rel cir
4990: WHERE sua.person_id = p_person_id
4991: AND sua.course_cd = p_course_cd
4992: AND sua.unit_attempt_status = 'COMPLETED'
4993: AND sua.cal_type = cir.sub_cal_type