THRESHOLD_FROM_DATA_UPDATION_QRY

/* Formatted on 14-09-2011 17:34:37 (QP5 v5.115.810.9015) */
CREATE TABLE JAI_AP_TDS_THHOLD_HDRS_BKUP AS SELECT * FROM Jai_Ap_Tds_Thhold_Hdrs;
CREATE TABLE JAI_AP_TDS_THHOLD_TYPES_BKUP AS SELECT * FROM JAI_AP_TDS_THHOLD_TYPES;

SELECT   *
  FROM   Jai_Ap_Tds_Thhold_Hdrs
 WHERE   threshold_hdr_id = :P_HEADER_ID;

SELECT   *
  FROM   JAI_AP_TDS_THHOLD_TYPES
 WHERE   threshold_hdr_id = :P_HEADER_ID;

UPDATE   JAI_AP_TDS_THHOLD_TYPES
   SET   from_date = '01-APR-2011'
 WHERE   threshold_hdr_id = :P_HEADER_ID;