APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on DUAL

Line 37: FROM dual;

33: IF batch_id IS NULL THEN
34: SELECT
35: IGS_AD_ACT_ASSESSMENTS_S.nextval
36: INTO batch_id
37: FROM dual;
38: END IF;
39: return batch_id;
40: END get_batch_id;
41:

Line 186: 'ACT-INSTITUTION','R','ACT-RESIDUAL','S','ACT-STATE','Z','ACT-ARRANGED','N','ACT-NATIONAL') ADMISSION_TEST_TYPE

182: cp_Test_Date IGS_AD_ACT_ASSESSMENTS.TEST_DATE_TXT%type,
183: cp_ACT_Id IGS_AD_ACT_ASSESSMENTS.act_identifier%type) IS
184: SELECT
185: DISTINCT Decode (actas.Test_Type,'D','ACT-DANTES','F','ACT-INTERNATIONAL','I',
186: 'ACT-INSTITUTION','R','ACT-RESIDUAL','S','ACT-STATE','Z','ACT-ARRANGED','N','ACT-NATIONAL') ADMISSION_TEST_TYPE
187: FROM IGS_AD_ACT_ASSESSMENTS actas
188: WHERE actas.ACT_Batch_ID = cp_ACT_Batch_Id
189: AND actas.Reporting_Year like nvl(cp_Reporting_Year,'%')
190: AND actas.Test_Type like nvl(cp_Test_Type,'%')

Line 209: 'ACT-INSTITUTION','R','ACT-RESIDUAL','S','ACT-STATE','Z','ACT-ARRANGED','N','ACT-NATIONAL') ADMISSION_TEST_TYPE,

205: cp_test_date IGS_AD_ACT_ASSESSMENTS.TEST_DATE_TXT%type,
206: cp_act_id IGS_AD_ACT_ASSESSMENTS.act_identifier%type) IS
207: SELECT/*+ no_expand */
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

Line 868: 'ACT-INSTITUTION','R','ACT-RESIDUAL','S','ACT-STATE','Z','ACT-ARRANGED','N','ACT-NATIONAL'),

864: (
865: IGS_AD_TEST_INT_S.NEXTVAL,
866: l_interface_id,
867: Decode (Act_Assessment_rec.test_type,'D','ACT-DANTES','F','ACT-INTERNATIONAL','I',
868: 'ACT-INSTITUTION','R','ACT-RESIDUAL','S','ACT-STATE','Z','ACT-ARRANGED','N','ACT-NATIONAL'),
869: to_date( Act_Assessment_rec.test_date_txt||'01','YYYYMMDD'),
870: 'OFFICIAL',
871: G_Score_Source_id,
872: SYSDATE,