APPS.OKL_AM_ASSET_RELOCATION_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 212

   SELECT 'x'
   FROM   fa_locations
   WHERE  location_id = p_location_id
   AND    enabled_flag = 'Y'
   AND    p_sysdate BETWEEN NVL(START_DATE_ACTIVE,p_sysdate) AND NVL(END_DATE_ACTIVE,p_sysdate);

Line: 220

   SELECT book_type_code
   FROM   fa_book_controls
   WHERE  distribution_source_book = p_source
   AND    book_class = 'TAX'
   AND    date_ineffective IS NULL;

Line: 228

   SELECT count(*)
   FROM   fa_deprn_summary ds, fa_book_controls bc
   WHERE  bc.book_type_code = p_book_type_code
   AND    ds.book_type_code = bc.book_type_code
   AND    ds.period_counter = bc.last_period_counter + 1
   AND    ds.asset_id = p_asset_id
   AND    ds.deprn_source_code = 'DEPRN';

Line: 254

      SELECT SYSDATE INTO l_sysdate FROM DUAL;

Line: 517

                    l_asset_dist_tbl.DELETE;

Line: 785

	-- Update Item Instance generic parameters
	l_instance_rec		instance_rec;

Line: 790

	-- Update Item Instance specific parameters
	l_ext_attrib_values_tbl	extend_attrib_values_tbl;

Line: 900

	-- Call Installed Base API to update item
	-- **************************************

	csi_item_instance_pub.update_item_instance (
		p_api_version		=> l_api_version,
		p_commit		=> FND_API.G_FALSE,
		p_init_msg_list		=> FND_API.G_FALSE,
		p_validation_level	=> FND_API.G_VALID_LEVEL_FULL,
		p_instance_rec		=> l_instance_rec,
		p_ext_attrib_values_tbl	=> l_ext_attrib_values_tbl,
		p_party_tbl		=> l_party_tbl,
		p_account_tbl		=> l_account_tbl,
		p_pricing_attrib_tbl	=> l_pricing_attrib_tbl,
		p_org_assignments_tbl	=> l_org_assignments_tbl,
		p_asset_assignment_tbl	=> l_asset_assignment_tbl,
		p_txn_rec		=> l_txn_rec,
		x_instance_id_lst	=> l_instance_id_lst,
		x_return_status		=> l_return_status,
		x_msg_count		=> l_msg_count,
		x_msg_data		=> l_msg_data);