295: LAST_UPDATED_BY,
296: LAST_UPDATE_LOGIN,
297: CREATION_DATE,
298: CREATED_BY
299: from igi_cis_mth_ret_lines_t
300: where HEADER_ID = p_in_header_id ;
301: insert into igi_cis_mth_ret_pay_h
302: (HEADER_ID,
303: ORG_ID,
335: DISCOUNT_AMOUNT
336: from igi_cis_mth_ret_pay_t
337: where HEADER_ID = p_in_header_id ;
338: delete from igi_cis_mth_ret_hdr_t where header_id = p_in_header_id;
339: delete from igi_cis_mth_ret_lines_t where header_id = p_in_header_id;
340: delete from igi_cis_mth_ret_pay_t where header_id = p_in_header_id;
341: commit;
342: ELSE
343: null;