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_AD_UP_HEADER

Line 3081: igs_ad_up_header h

3077: FROM igs_ad_up_detail d
3078: WHERE EXISTS (
3079: SELECT 'x'
3080: FROM igs_ad_test_results atr,
3081: igs_ad_up_header h
3082: WHERE atr.person_id = p_person_id
3083: AND atr.admission_test_type = h.admission_test_type
3084: AND h.up_header_id = d.up_header_id);
3085: PROCEDURE val_placement (pp_unit_cd IN IGS_PS_UNIT_VER.UNIT_CD%TYPE,

Line 3099: igs_ad_up_header hed

3095: definition_level,
3096: min_score,
3097: max_score
3098: FROM igs_ad_up_detail det,
3099: igs_ad_up_header hed
3100: WHERE det.up_header_id = hed.up_header_id
3101: AND det.unit_cd = cp_unit_cd
3102: AND det.closed_ind ='N';
3103: CURSOR cur_test(cp_person_id igs_pe_person.person_id%TYPE,

Line 3104: cp_admission_test_type igs_ad_up_header.admission_test_type%TYPE,

3100: WHERE det.up_header_id = hed.up_header_id
3101: AND det.unit_cd = cp_unit_cd
3102: AND det.closed_ind ='N';
3103: CURSOR cur_test(cp_person_id igs_pe_person.person_id%TYPE,
3104: cp_admission_test_type igs_ad_up_header.admission_test_type%TYPE,
3105: cp_min_score igs_ad_up_header.min_score%TYPE,
3106: cp_max_score igs_ad_up_header.max_score%TYPE ) IS
3107: SELECT '1' FROM IGS_AD_TEST_RESULTS
3108: WHERE person_id = cp_person_id

Line 3105: cp_min_score igs_ad_up_header.min_score%TYPE,

3101: AND det.unit_cd = cp_unit_cd
3102: AND det.closed_ind ='N';
3103: CURSOR cur_test(cp_person_id igs_pe_person.person_id%TYPE,
3104: cp_admission_test_type igs_ad_up_header.admission_test_type%TYPE,
3105: cp_min_score igs_ad_up_header.min_score%TYPE,
3106: cp_max_score igs_ad_up_header.max_score%TYPE ) IS
3107: SELECT '1' FROM IGS_AD_TEST_RESULTS
3108: WHERE person_id = cp_person_id
3109: AND admission_test_type = cp_admission_test_type

Line 3106: cp_max_score igs_ad_up_header.max_score%TYPE ) IS

3102: AND det.closed_ind ='N';
3103: CURSOR cur_test(cp_person_id igs_pe_person.person_id%TYPE,
3104: cp_admission_test_type igs_ad_up_header.admission_test_type%TYPE,
3105: cp_min_score igs_ad_up_header.min_score%TYPE,
3106: cp_max_score igs_ad_up_header.max_score%TYPE ) IS
3107: SELECT '1' FROM IGS_AD_TEST_RESULTS
3108: WHERE person_id = cp_person_id
3109: AND admission_test_type = cp_admission_test_type
3110: AND NVL(comp_test_score,0) BETWEEN cp_min_score AND cp_max_score;

Line 3113: cp_admission_test_type igs_ad_up_header.admission_test_type%TYPE,

3109: AND admission_test_type = cp_admission_test_type
3110: AND NVL(comp_test_score,0) BETWEEN cp_min_score AND cp_max_score;
3111: --
3112: CURSOR cur_seg (cp_person_id igs_pe_person.person_id%TYPE,
3113: cp_admission_test_type igs_ad_up_header.admission_test_type%TYPE,
3114: cp_test_segment_id igs_ad_up_header.test_segment_id%TYPE,
3115: cp_min_score igs_ad_up_header.min_score%TYPE,
3116: cp_max_score igs_ad_up_header.max_score%TYPE ) IS
3117: SELECT '1' FROM IGS_AD_TEST_RESULTS TST,

Line 3114: cp_test_segment_id igs_ad_up_header.test_segment_id%TYPE,

3110: AND NVL(comp_test_score,0) BETWEEN cp_min_score AND cp_max_score;
3111: --
3112: CURSOR cur_seg (cp_person_id igs_pe_person.person_id%TYPE,
3113: cp_admission_test_type igs_ad_up_header.admission_test_type%TYPE,
3114: cp_test_segment_id igs_ad_up_header.test_segment_id%TYPE,
3115: cp_min_score igs_ad_up_header.min_score%TYPE,
3116: cp_max_score igs_ad_up_header.max_score%TYPE ) IS
3117: SELECT '1' FROM IGS_AD_TEST_RESULTS TST,
3118: IGS_AD_TST_RSLT_DTLS TDTL

Line 3115: cp_min_score igs_ad_up_header.min_score%TYPE,

3111: --
3112: CURSOR cur_seg (cp_person_id igs_pe_person.person_id%TYPE,
3113: cp_admission_test_type igs_ad_up_header.admission_test_type%TYPE,
3114: cp_test_segment_id igs_ad_up_header.test_segment_id%TYPE,
3115: cp_min_score igs_ad_up_header.min_score%TYPE,
3116: cp_max_score igs_ad_up_header.max_score%TYPE ) IS
3117: SELECT '1' FROM IGS_AD_TEST_RESULTS TST,
3118: IGS_AD_TST_RSLT_DTLS TDTL
3119: WHERE tst.person_id = cp_person_id

Line 3116: cp_max_score igs_ad_up_header.max_score%TYPE ) IS

3112: CURSOR cur_seg (cp_person_id igs_pe_person.person_id%TYPE,
3113: cp_admission_test_type igs_ad_up_header.admission_test_type%TYPE,
3114: cp_test_segment_id igs_ad_up_header.test_segment_id%TYPE,
3115: cp_min_score igs_ad_up_header.min_score%TYPE,
3116: cp_max_score igs_ad_up_header.max_score%TYPE ) IS
3117: SELECT '1' FROM IGS_AD_TEST_RESULTS TST,
3118: IGS_AD_TST_RSLT_DTLS TDTL
3119: WHERE tst.person_id = cp_person_id
3120: AND tst.admission_test_type = cp_admission_test_type