66: ORDER BY LOAD_START_DT ASC;
67:
68: CURSOR c_reason IS
69: SELECT meaning
70: FROM IGS_LOOKUPS_VIEW
71: WHERE lookup_type = 'CRS_ATTEMPT_STATUS'
72: AND lookup_CODE = 'INTERMIT';
73:
74: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
73:
74: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
75: l_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
76: l_return_status VARCHAR2(10);
77: l_meaning IGS_LOOKUPS_VIEW.MEANING%TYPE;
78:
79: BEGIN
80:
81: OPEN c_tl;