[Home] [Help]
1433:
1434: BEGIN
1435: SELECT non_src_status_id
1436: INTO l_ns_instance_rec.instance_status_id
1437: FROM csi_txn_sub_types
1438: WHERE transaction_type_id = p_trx_rec.transaction_type_id
1439: AND sub_type_id = p_txn_line_detail_rec.sub_type_id;
1440: EXCEPTION
1441: WHEN no_data_found THEN