APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_AD_TEST_SEGMENTS

Line 360: igs_ad_test_segments.test_segment_name%TYPE,

356: CURSOR c_tst_rslt_dtls_id (cp_admission_test_type
357: igs_ad_test_results.admission_test_type%TYPE,
358: cp_test_date igs_ad_test_results.test_date%TYPE,
359: cp_test_segment_name
360: igs_ad_test_segments.test_segment_name%TYPE,
361: cp_person_id igs_ad_test_results.person_id%TYPE) IS
362: SELECT b.tst_rslt_dtls_id
363: FROM igs_ad_test_results a,
364: igs_ad_tst_rslt_dtls b,

Line 365: igs_ad_test_segments c

361: cp_person_id igs_ad_test_results.person_id%TYPE) IS
362: SELECT b.tst_rslt_dtls_id
363: FROM igs_ad_test_results a,
364: igs_ad_tst_rslt_dtls b,
365: igs_ad_test_segments c
366: WHERE a.test_results_id = b.test_results_id
367: AND c.admission_test_type = cp_admission_test_type
368: AND b.test_segment_id = c.test_segment_id
369: AND a.admission_test_type = cp_admission_test_type