APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_AD_ACT_STATISTICS

Line 212: FROM IGS_AD_ACT_STATISTICS aas ,

208: DISTINCT Decode (aas.Test_Type,'D','ACT-DANTES','F','ACT-INTERNATIONAL','I',
209: 'ACT-INSTITUTION','R','ACT-RESIDUAL','S','ACT-STATE','Z','ACT-ARRANGED','N','ACT-NATIONAL') ADMISSION_TEST_TYPE,
210: Decode(aas.STATISTIC_TYPE,'TEST','SCORE','TEST_SUB_SCORE','SUB SCORE') SEGMENT_TYPE,
211: lkv.meaning TEST_SEGMENT_NAME
212: FROM IGS_AD_ACT_STATISTICS aas ,
213: IGS_LOOKUP_VALUES lkv
214: WHERE aas.Reporting_Year like nvl(cp_Reporting_Year,'%')
215: AND aas.Test_Type like nvl(cp_Test_Type,'%')
216: AND aas.TEST_DATE_TXT like nvl(cp_Test_Date,'%')

Line 425: FROM IGS_AD_ACT_STATISTICS

421: cp_test_date IGS_AD_ACT_ASSESSMENTS.TEST_DATE_TXT%type,
422: cp_act_id IGS_AD_ACT_ASSESSMENTS.act_identifier%type) IS
423: SELECT
424: *
425: FROM IGS_AD_ACT_STATISTICS
426: WHERE REPORTING_YEAR = cp_reporting_year
427: AND TEST_TYPE = cp_test_type
428: AND TEST_DATE_TXT = cp_test_date
429: AND ACT_Identifier = cp_act_id

Line 443: FROM IGS_AD_ACT_STATISTICS

439: cp_test_date IGS_AD_ACT_ASSESSMENTS.TEST_DATE_TXT%type,
440: cp_act_id IGS_AD_ACT_ASSESSMENTS.act_identifier%type) IS
441: SELECT
442: *
443: FROM IGS_AD_ACT_STATISTICS
444: WHERE REPORTING_YEAR = cp_reporting_year
445: AND TEST_TYPE = cp_test_type
446: AND TEST_DATE_TXT = cp_test_date
447: AND ACT_Identifier = cp_act_id

Line 473: l_national_percentile igs_ad_act_statistics.national_norm%type;

469: l_High_School_Graduation igs_Ad_Act_Assessments.High_School_Graduation%type;
470:
471: l_test_segment_id igs_ad_test_segs_int.test_segment_id%type;
472: l_test_score igs_ad_test_segs_int.test_score%type;
473: l_national_percentile igs_ad_act_statistics.national_norm%type;
474: l_state_percentile igs_ad_act_statistics.local_norm%type;
475: l_score_band_upper igs_ad_test_segs_int.score_band_upper%type;
476: l_score_band_lower igs_ad_test_segs_int.score_band_lower%type;
477: l_grade VARCHAR2(10);

Line 474: l_state_percentile igs_ad_act_statistics.local_norm%type;

470:
471: l_test_segment_id igs_ad_test_segs_int.test_segment_id%type;
472: l_test_score igs_ad_test_segs_int.test_score%type;
473: l_national_percentile igs_ad_act_statistics.national_norm%type;
474: l_state_percentile igs_ad_act_statistics.local_norm%type;
475: l_score_band_upper igs_ad_test_segs_int.score_band_upper%type;
476: l_score_band_lower igs_ad_test_segs_int.score_band_lower%type;
477: l_grade VARCHAR2(10);
478: l_Statistic_Category_desc igs_lookup_values.MEANING%type;