APPS.IGS_AD_IMP_UH_TST_PKG dependencies on IGS_AD_TEST_SEGMENTS

Line 118: FROM IGS_AD_TEST_SEGMENTS

114: WHERE A.INTERFACE_TST_ID = B.INTERFACE_TST_ID
115: AND A.PERSON_ID = p_person_id
116: AND A.SESSION_ID = p_session_id
117: AND B.TEST_SEGMENT_ID IN (SELECT TEST_SEGMENT_ID
118: FROM IGS_AD_TEST_SEGMENTS
119: WHERE INCLUDE_IN_COMP_SCORE ='Y'
120: AND ADMISSION_TEST_TYPE IN
121: ( SELECT distinct admission_test_type
122: FROM IGS_AD_TEST_RESULTS