332: MATERIAL_COST,
333: TOTAL_DEDUCTIONS,
334: CIS_TAX,
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;
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;
344: END IF;