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_GE_DATE

Line 64: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =

60: ci.CAL_TYPE = p_acad_cal_type AND
61: ci.sequence_number = p_acad_ci_sequence_number AND
62: ((sca.course_rqrmnts_complete_dt BETWEEN ci.start_dt AND ci.end_dt) OR
63: (sca.course_rqrmnts_complete_dt >
64: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
65: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
66: p_person_id,
67: p_course_cd,
68: p_include_fail_grade_ind,

Line 92: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =

88: ci.CAL_TYPE = p_acad_cal_type AND
89: ci.sequence_number = p_acad_ci_sequence_number AND
90: ((sca.course_rqrmnts_complete_dt BETWEEN ci.start_dt AND ci.end_dt) OR
91: (sca.course_rqrmnts_complete_dt >
92: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
93: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
94: p_person_id,
95: p_course_cd,
96: p_include_fail_grade_ind,

Line 297: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =

293: ci.CAL_TYPE = p_acad_cal_type AND
294: ci.sequence_number = p_acad_ci_sequence_number AND
295: ((sca.commencement_dt BETWEEN ci.start_dt AND ci.end_dt) OR
296: (sca.commencement_dt >
297: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
298: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
299: p_person_id,
300: p_course_cd,
301: p_include_fail_grade_ind,

Line 434: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =

430: ci.sequence_number = p_acad_ci_sequence_number AND
431: (((susa.selection_dt BETWEEN ci.start_dt AND ci.end_dt) OR
432: (susa.rqrmnts_complete_dt BETWEEN ci.start_dt AND ci.end_dt)) OR
433: (susa.selection_dt >
434: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
435: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
436: p_person_id,
437: p_course_cd,
438: p_include_fail_grade_ind,

Line 444: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =

440: p_exclude_research_units_ind,
441: p_exclude_unit_category,
442: p_include_related_crs_ind)) OR
443: (susa.rqrmnts_complete_dt >
444: ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
445: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
446: p_person_id,
447: p_course_cd,
448: p_include_fail_grade_ind,

Line 992: (sci.start_dt > ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =

988: sci.end_dt IS NOT NULL AND
989: ci.CAL_TYPE = p_acad_cal_type AND
990: ci.sequence_number = p_acad_ci_sequence_number AND
991: ((sci.start_dt BETWEEN ci.start_dt AND ci.end_dt) OR
992: (sci.start_dt > ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
993: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
994: p_person_id,
995: p_course_cd,
996: p_include_fail_grade_ind,

Line 1020: (sca.lapsed_dt > ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =

1016: sca.lapsed_dt IS NOT NULL AND
1017: ci.CAL_TYPE = p_acad_cal_type AND
1018: ci.sequence_number = p_acad_ci_sequence_number AND
1019: ((sca.lapsed_dt BETWEEN ci.start_dt AND ci.end_dt) OR
1020: (sca.lapsed_dt > ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
1021: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
1022: p_person_id,
1023: p_course_cd,
1024: p_include_fail_grade_ind,

Line 1048: (sca.discontinued_dt > ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =

1044: sca.discontinued_dt IS NOT NULL AND
1045: ci.CAL_TYPE = p_acad_cal_type AND
1046: ci.sequence_number = p_acad_ci_sequence_number AND
1047: ((sca.discontinued_dt BETWEEN ci.start_dt AND ci.end_dt) OR
1048: (sca.discontinued_dt > ci.start_dt AND SUBSTR(IGS_GE_DATE.IGSCHAR(ci.start_dt),1,4) =
1049: IGS_AS_GEN_005.ASSP_VAL_SCA_FINAL (
1050: p_person_id,
1051: p_course_cd,
1052: p_include_fail_grade_ind,

Line 1524: SELECT SUBSTR(IGS_GE_DATE.IGSCHAR(start_dt),1,4)

1520: asule.s_adv_stnd_granting_status = 'GRANTED'
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

Line 1691: SELECT SUBSTR(IGS_GE_DATE.IGSCHAR(start_dt),1,4)

1687: ORDER BY
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

Line 1870: SELECT SUBSTR(IGS_GE_DATE.IGSCHAR(start_dt),1,4)

1866: WHERE asule.person_id = adv.person_id AND
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