[Home] [Help]
291: IF c_check_bal_seg_val%NOTFOUND THEN
292: CLOSE c_check_bal_seg_val;
293: ELSE
294: CLOSE c_check_bal_seg_val;
295: UPDATE gcs_data_sub_dtls
296: SET status_code = 'IMPACTED'
297: WHERE cal_period_id = l_ledger_period_bsv_info(l_ledger_period_bsv_index).cal_period_id
298: AND entity_id = rec_entity.entity_id
299: AND currency_code = row_inner_rec.currency_code