APPS.PQH_PLG_SHD SQL Statements

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

Line: 55

    select
		process_log_id,
	module_cd,
	txn_id,
	master_process_log_id,
	message_text,
	message_type_cd,
	batch_status,
	batch_start_date,
	batch_end_date,
	txn_table_route_id,
	log_context,
	information_category,
	information1,
	information2,
	information3,
	information4,
	information5,
	information6,
	information7,
	information8,
	information9,
	information10,
	information11,
	information12,
	information13,
	information14,
	information15,
	information16,
	information17,
	information18,
	information19,
	information20,
	information21,
	information22,
	information23,
	information24,
	information25,
	information26,
	information27,
	information28,
	information29,
	information30,
	object_version_number
    from	pqh_process_log
    where	process_log_id = p_process_log_id;

Line: 168

    select 	process_log_id,
	module_cd,
	txn_id,
	master_process_log_id,
	message_text,
	message_type_cd,
	batch_status,
	batch_start_date,
	batch_end_date,
	txn_table_route_id,
	log_context,
	information_category,
	information1,
	information2,
	information3,
	information4,
	information5,
	information6,
	information7,
	information8,
	information9,
	information10,
	information11,
	information12,
	information13,
	information14,
	information15,
	information16,
	information17,
	information18,
	information19,
	information20,
	information21,
	information22,
	information23,
	information24,
	information25,
	information26,
	information27,
	information28,
	information29,
	information30,
	object_version_number
    from	pqh_process_log
    where	process_log_id = p_process_log_id
    for	update nowait;