APPS.IGS_AV_LVL_LGCY_PUB dependencies on IGS_AD_TEST_RESULTS

Line 1058: CURSOR c_tst_rslt_dtls_id (cp_admission_test_type igs_ad_test_results.admission_test_type%TYPE,

1054: */
1055:
1056: IF p_lgcy_adstlvl_rec.tst_admission_test_type IS NOT NULL THEN
1057: DECLARE
1058: CURSOR c_tst_rslt_dtls_id (cp_admission_test_type igs_ad_test_results.admission_test_type%TYPE,
1059: cp_test_date igs_ad_test_results.test_date%TYPE,
1060: cp_test_segment_name igs_ad_test_segments.test_segment_name%TYPE,
1061: cp_person_id igs_ad_test_results.person_id%TYPE
1062: ) IS

Line 1059: cp_test_date igs_ad_test_results.test_date%TYPE,

1055:
1056: IF p_lgcy_adstlvl_rec.tst_admission_test_type IS NOT NULL THEN
1057: DECLARE
1058: CURSOR c_tst_rslt_dtls_id (cp_admission_test_type igs_ad_test_results.admission_test_type%TYPE,
1059: cp_test_date igs_ad_test_results.test_date%TYPE,
1060: cp_test_segment_name igs_ad_test_segments.test_segment_name%TYPE,
1061: cp_person_id igs_ad_test_results.person_id%TYPE
1062: ) IS
1063: SELECT b.tst_rslt_dtls_id

Line 1061: cp_person_id igs_ad_test_results.person_id%TYPE

1057: DECLARE
1058: CURSOR c_tst_rslt_dtls_id (cp_admission_test_type igs_ad_test_results.admission_test_type%TYPE,
1059: cp_test_date igs_ad_test_results.test_date%TYPE,
1060: cp_test_segment_name igs_ad_test_segments.test_segment_name%TYPE,
1061: cp_person_id igs_ad_test_results.person_id%TYPE
1062: ) IS
1063: SELECT b.tst_rslt_dtls_id
1064: FROM igs_ad_test_results a,
1065: igs_ad_tst_rslt_dtls b,

Line 1064: FROM igs_ad_test_results a,

1060: cp_test_segment_name igs_ad_test_segments.test_segment_name%TYPE,
1061: cp_person_id igs_ad_test_results.person_id%TYPE
1062: ) IS
1063: SELECT b.tst_rslt_dtls_id
1064: FROM igs_ad_test_results a,
1065: igs_ad_tst_rslt_dtls b,
1066: igs_ad_test_segments c
1067: WHERE a.test_results_id = b.test_results_id
1068: AND b.test_segment_id = c.test_segment_id