[Home] [Help]
97: AND isirm.base_id = NVL(p_base_id, isirm.base_id)
98: AND far.ci_cal_type = gv_cal_type
99: AND far.ci_sequence_number = gn_sequence_number
100: AND isirm.isir_id IN (SELECT DISTINCT c.isir_id
101: FROM igf_ap_isir_corr_all c
102: WHERE c.correction_status = 'READY' );
103:
104:
105: CURSOR cur_corr_isir (gn_baseid NUMBER ,