APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_AD_TEST_RESULTS

Line 357: igs_ad_test_results.admission_test_type%TYPE,

353: AND ahv.institution_code = cp_institution_code ;
354:
355:
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

Line 358: cp_test_date igs_ad_test_results.test_date%TYPE,

354:
355:
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

Line 361: cp_person_id igs_ad_test_results.person_id%TYPE) IS

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,
365: igs_ad_test_segments c

Line 363: FROM igs_ad_test_results a,

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,
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