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.

APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_CA_INST

Line 50: IGS_CA_INST ci,

46: aw.award_title
47: FROM IGS_EN_STDNT_PS_ATT sca,
48: IGS_GR_GRADUAND gr,
49: IGS_GR_STAT gst,
50: IGS_CA_INST ci,
51: IGS_PS_AWD aw
52: WHERE sca.person_id = p_person_id AND
53: sca.course_cd = p_course_cd AND
54: sca.course_rqrmnt_complete_ind = 'Y' AND

Line 84: IGS_CA_INST ci

80: SYSDATE,
81: NULL,
82: NULL
83: FROM IGS_EN_STDNT_PS_ATT sca,
84: IGS_CA_INST ci
85: WHERE sca.person_id = p_person_id AND
86: sca.course_cd = p_course_cd AND
87: sca.course_rqrmnt_complete_ind = 'Y' AND
88: ci.CAL_TYPE = p_acad_cal_type AND

Line 286: IGS_CA_INST ci

282: ci.alternate_code
283: FROM IGS_RE_CANDIDATURE ca,
284: IGS_RE_THESIS th,
285: IGS_EN_STDNT_PS_ATT sca,
286: IGS_CA_INST ci
287: WHERE ca.person_id = p_person_id AND
288: ca.sca_course_cd = p_course_cd AND
289: ca.person_id = th.person_id AND
290: ca.sequence_number = th.ca_sequence_number AND

Line 420: IGS_CA_INST ci

416: susa.primary_set_ind
417: FROM IGS_AS_SU_SETATMPT susa,
418: IGS_EN_UNIT_SET us,
419: IGS_EN_UNIT_SET_CAT usc,
420: IGS_CA_INST ci
421: WHERE susa.person_id = p_person_id AND
422: susa.course_cd = p_course_cd AND
423: susa.student_confirmed_ind = 'Y' AND
424: susa.rqrmnts_complete_ind = 'Y' AND

Line 663: igs_ca_inst ci

659: igs_ps_stdnt_trn sct,
660: igs_en_su_attempt_all suav,
661: igs_ps_usec_cps cps,
662: igs_ps_unit_ver uv,
663: igs_ca_inst ci
664: WHERE sut.person_id = p_person_id
665: AND sut.course_cd = p_to_course_cd
666: AND sut.person_id = sct.person_id
667: AND sut.course_cd = sct.course_cd

Line 832: IGS_CA_INST ci

828: sct.course_cd,
829: sct.transfer_dt,
830: ci.alternate_code
831: FROM IGS_PS_STDNT_TRN sct,
832: IGS_CA_INST ci
833: WHERE sct.person_id = p_person_id AND
834: sct.course_cd = p_course_cd AND
835: ci.CAL_TYPE = p_acad_cal_type AND
836: ci.sequence_number = p_acad_ci_sequence_number AND

Line 844: IGS_CA_INST ci

840: CURSOR c_sut (
841: cp_from_course_cd IGS_PS_STDNT_UNT_TRN.transfer_course_cd%TYPE) IS
842: SELECT sut.unit_cd
843: FROM IGS_PS_STDNT_UNT_TRN sut,
844: IGS_CA_INST ci
845: WHERE sut.person_id = p_person_id AND
846: sut.course_cd = p_course_cd AND
847: sut.transfer_course_cd = cp_from_course_cd AND
848: ci.CAL_TYPE = p_acad_cal_type AND

Line 985: IGS_CA_INST ci

981: SYSDATE ,
982: NULL n2,
983: NULL n3
984: FROM IGS_EN_STDNT_PS_INTM sci,
985: IGS_CA_INST ci
986: WHERE sci.person_id = p_person_id AND
987: sci.course_cd = p_course_cd AND
988: sci.end_dt IS NOT NULL AND
989: ci.CAL_TYPE = p_acad_cal_type AND

Line 1013: IGS_CA_INST ci

1009: SYSDATE,
1010: NULL n5,
1011: NULL n6
1012: FROM IGS_EN_STDNT_PS_ATT sca,
1013: IGS_CA_INST ci
1014: WHERE sca.person_id = p_person_id AND
1015: sca.course_cd = p_course_cd AND
1016: sca.lapsed_dt IS NOT NULL AND
1017: ci.CAL_TYPE = p_acad_cal_type AND

Line 1041: IGS_CA_INST ci

1037: SYSDATE,
1038: NULL n8,
1039: NULL n9
1040: FROM IGS_EN_STDNT_PS_ATT sca,
1041: IGS_CA_INST ci
1042: WHERE sca.person_id = p_person_id AND
1043: sca.course_cd = p_course_cd AND
1044: sca.discontinued_dt IS NOT NULL AND
1045: ci.CAL_TYPE = p_acad_cal_type AND

Line 1272: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

1268: FUNCTION asspl_val_dsp_unit(
1269: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1270: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1271: p_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1272: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1273: p_sequence_number IGS_CA_INST.sequence_number%TYPE,
1274: -- anilk, 22-Apr-2003, Bug# 2829262
1275: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE )
1276: RETURN BOOLEAN IS

Line 1273: p_sequence_number IGS_CA_INST.sequence_number%TYPE,

1269: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1270: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1271: p_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
1272: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1273: p_sequence_number IGS_CA_INST.sequence_number%TYPE,
1274: -- anilk, 22-Apr-2003, Bug# 2829262
1275: p_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE )
1276: RETURN BOOLEAN IS
1277:

Line 1525: FROM IGS_CA_INST

1521: ORDER BY
1522: asule.UNIT_LEVEL;
1523: CURSOR c_current_yr IS
1524: SELECT SUBSTR(IGS_GE_DATE.IGSCHAR(start_dt),1,4)
1525: FROM IGS_CA_INST
1526: WHERE CAL_TYPE = p_acad_cal_type AND
1527: sequence_number = p_acad_ci_sequence_number;
1528: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
1529: SELECT 'x'

Line 1528: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS

1524: SELECT SUBSTR(IGS_GE_DATE.IGSCHAR(start_dt),1,4)
1525: FROM IGS_CA_INST
1526: WHERE CAL_TYPE = p_acad_cal_type AND
1527: sequence_number = p_acad_ci_sequence_number;
1528: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
1529: SELECT 'x'
1530: FROM dual
1531: WHERE cp_year <= IGS_AS_GEN_005.ASSP_VAL_SCA_COMM (
1532: p_person_id,

Line 1692: FROM IGS_CA_INST

1688: asu.unit_cd,
1689: asu.version_number;
1690: CURSOR c_current_yr IS
1691: SELECT SUBSTR(IGS_GE_DATE.IGSCHAR(start_dt),1,4)
1692: FROM IGS_CA_INST
1693: WHERE CAL_TYPE = p_acad_cal_type AND
1694: sequence_number = p_acad_ci_sequence_number;
1695: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
1696: SELECT 'x'

Line 1695: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS

1691: SELECT SUBSTR(IGS_GE_DATE.IGSCHAR(start_dt),1,4)
1692: FROM IGS_CA_INST
1693: WHERE CAL_TYPE = p_acad_cal_type AND
1694: sequence_number = p_acad_ci_sequence_number;
1695: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
1696: SELECT 'x'
1697: FROM dual
1698: WHERE cp_year <= IGS_AS_GEN_005.ASSP_VAL_SCA_COMM (
1699: p_person_id,

Line 1871: FROM IGS_CA_INST

1867: asule.as_course_cd = adv.course_cd AND
1868: asule.s_adv_stnd_granting_status = 'GRANTED'));
1869: CURSOR c_current_yr IS
1870: SELECT SUBSTR(IGS_GE_DATE.IGSCHAR(start_dt),1,4)
1871: FROM IGS_CA_INST
1872: WHERE CAL_TYPE = p_acad_cal_type AND
1873: sequence_number = p_acad_ci_sequence_number;
1874: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
1875: SELECT 'x'

Line 1874: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS

1870: SELECT SUBSTR(IGS_GE_DATE.IGSCHAR(start_dt),1,4)
1871: FROM IGS_CA_INST
1872: WHERE CAL_TYPE = p_acad_cal_type AND
1873: sequence_number = p_acad_ci_sequence_number;
1874: CURSOR c_check_yr (cp_year IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
1875: SELECT 'x'
1876: FROM dual
1877: WHERE cp_year <= IGS_AS_GEN_005.ASSP_VAL_SCA_COMM (
1878: p_person_id,

Line 2018: IGS_CA_INST ci

2014: FROM IGS_EN_STDNT_PS_ATT sca,
2015: IGS_EN_SUA_V suav,
2016: IGS_PS_VER cv,
2017: IGS_PS_OFR_PAT cop,
2018: IGS_CA_INST ci
2019: WHERE sca.person_id = p_person_id AND
2020: sca.person_id = suav.person_id AND
2021: sca.course_cd = suav.course_cd AND
2022: (sca.course_cd = NVL(p_course_cd, suav.course_cd) OR

Line 2112: IGS_CA_INST ci

2108: FROM IGS_EN_STDNT_PS_ATT sca,
2109: IGS_EN_SUA_V suav,
2110: IGS_PS_VER cv,
2111: IGS_PS_OFR_PAT cop,
2112: IGS_CA_INST ci
2113: WHERE sca.person_id = p_person_id AND
2114: sca.person_id = suav.person_id AND
2115: -- sca.course_cd = NVL(p_course_cd, suav.course_cd) AND
2116: sca.course_cd = suav.course_cd AND