22: v_dummy VARCHAR2(1);
23: CURSOR c_start_ci IS
24: SELECT 'X'
25: FROM IGS_CA_INST ci,
26: IGS_CA_STAT cs
27: WHERE ci.cal_type = p_prg_cal_type AND
28: ci.sequence_number = p_start_sequence_number AND
29: ci.cal_status = cs.cal_status AND
30: cs.s_cal_status = 'ACTIVE';
30: cs.s_cal_status = 'ACTIVE';
31: CURSOR c_end_ci IS
32: SELECT 'X'
33: FROM IGS_CA_INST ci,
34: IGS_CA_STAT cs
35: WHERE ci.cal_type = p_prg_cal_type AND
36: ci.sequence_number = p_end_sequence_number AND
37: ci.cal_status = cs.cal_status AND
38: cs.s_cal_status = 'ACTIVE';