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_HE_IDENTIFY_TARGET_POP dependencies on IGS_HE_POOUS

Line 810: CURSOR cur_he_poous(cp_course_cd igs_he_poous.course_cd%TYPE,

806:
807: l_spa c_spa%ROWTYPE;
808:
809: -- Get the location of study and mode of study for deriving LOCSDY and MODE values
810: CURSOR cur_he_poous(cp_course_cd igs_he_poous.course_cd%TYPE,
811: cp_version_number igs_he_poous.crv_version_number%TYPE,
812: cp_cal_type igs_he_poous.cal_type%TYPE,
813: cp_location_cd igs_he_poous.location_cd%TYPE,
814: cp_attendance_mode igs_he_poous.attendance_mode%TYPE,

Line 811: cp_version_number igs_he_poous.crv_version_number%TYPE,

807: l_spa c_spa%ROWTYPE;
808:
809: -- Get the location of study and mode of study for deriving LOCSDY and MODE values
810: CURSOR cur_he_poous(cp_course_cd igs_he_poous.course_cd%TYPE,
811: cp_version_number igs_he_poous.crv_version_number%TYPE,
812: cp_cal_type igs_he_poous.cal_type%TYPE,
813: cp_location_cd igs_he_poous.location_cd%TYPE,
814: cp_attendance_mode igs_he_poous.attendance_mode%TYPE,
815: cp_attendance_type igs_he_poous.attendance_type%TYPE,

Line 812: cp_cal_type igs_he_poous.cal_type%TYPE,

808:
809: -- Get the location of study and mode of study for deriving LOCSDY and MODE values
810: CURSOR cur_he_poous(cp_course_cd igs_he_poous.course_cd%TYPE,
811: cp_version_number igs_he_poous.crv_version_number%TYPE,
812: cp_cal_type igs_he_poous.cal_type%TYPE,
813: cp_location_cd igs_he_poous.location_cd%TYPE,
814: cp_attendance_mode igs_he_poous.attendance_mode%TYPE,
815: cp_attendance_type igs_he_poous.attendance_type%TYPE,
816: cp_unit_set_cd igs_he_poous.unit_set_cd%TYPE,

Line 813: cp_location_cd igs_he_poous.location_cd%TYPE,

809: -- Get the location of study and mode of study for deriving LOCSDY and MODE values
810: CURSOR cur_he_poous(cp_course_cd igs_he_poous.course_cd%TYPE,
811: cp_version_number igs_he_poous.crv_version_number%TYPE,
812: cp_cal_type igs_he_poous.cal_type%TYPE,
813: cp_location_cd igs_he_poous.location_cd%TYPE,
814: cp_attendance_mode igs_he_poous.attendance_mode%TYPE,
815: cp_attendance_type igs_he_poous.attendance_type%TYPE,
816: cp_unit_set_cd igs_he_poous.unit_set_cd%TYPE,
817: cp_us_version_number igs_he_poous.us_version_number%TYPE) IS

Line 814: cp_attendance_mode igs_he_poous.attendance_mode%TYPE,

810: CURSOR cur_he_poous(cp_course_cd igs_he_poous.course_cd%TYPE,
811: cp_version_number igs_he_poous.crv_version_number%TYPE,
812: cp_cal_type igs_he_poous.cal_type%TYPE,
813: cp_location_cd igs_he_poous.location_cd%TYPE,
814: cp_attendance_mode igs_he_poous.attendance_mode%TYPE,
815: cp_attendance_type igs_he_poous.attendance_type%TYPE,
816: cp_unit_set_cd igs_he_poous.unit_set_cd%TYPE,
817: cp_us_version_number igs_he_poous.us_version_number%TYPE) IS
818: SELECT location_of_study,

Line 815: cp_attendance_type igs_he_poous.attendance_type%TYPE,

811: cp_version_number igs_he_poous.crv_version_number%TYPE,
812: cp_cal_type igs_he_poous.cal_type%TYPE,
813: cp_location_cd igs_he_poous.location_cd%TYPE,
814: cp_attendance_mode igs_he_poous.attendance_mode%TYPE,
815: cp_attendance_type igs_he_poous.attendance_type%TYPE,
816: cp_unit_set_cd igs_he_poous.unit_set_cd%TYPE,
817: cp_us_version_number igs_he_poous.us_version_number%TYPE) IS
818: SELECT location_of_study,
819: mode_of_study

Line 816: cp_unit_set_cd igs_he_poous.unit_set_cd%TYPE,

812: cp_cal_type igs_he_poous.cal_type%TYPE,
813: cp_location_cd igs_he_poous.location_cd%TYPE,
814: cp_attendance_mode igs_he_poous.attendance_mode%TYPE,
815: cp_attendance_type igs_he_poous.attendance_type%TYPE,
816: cp_unit_set_cd igs_he_poous.unit_set_cd%TYPE,
817: cp_us_version_number igs_he_poous.us_version_number%TYPE) IS
818: SELECT location_of_study,
819: mode_of_study
820: FROM igs_he_poous

Line 817: cp_us_version_number igs_he_poous.us_version_number%TYPE) IS

813: cp_location_cd igs_he_poous.location_cd%TYPE,
814: cp_attendance_mode igs_he_poous.attendance_mode%TYPE,
815: cp_attendance_type igs_he_poous.attendance_type%TYPE,
816: cp_unit_set_cd igs_he_poous.unit_set_cd%TYPE,
817: cp_us_version_number igs_he_poous.us_version_number%TYPE) IS
818: SELECT location_of_study,
819: mode_of_study
820: FROM igs_he_poous
821: WHERE course_cd = cp_course_cd

Line 820: FROM igs_he_poous

816: cp_unit_set_cd igs_he_poous.unit_set_cd%TYPE,
817: cp_us_version_number igs_he_poous.us_version_number%TYPE) IS
818: SELECT location_of_study,
819: mode_of_study
820: FROM igs_he_poous
821: WHERE course_cd = cp_course_cd
822: AND crv_version_number = cp_version_number
823: AND cal_type = cp_cal_type
824: AND location_cd = cp_location_cd