APPS.PQH_CET_SHD SQL Statements

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

Line: 65

    select
		copy_entity_txn_id,
	transaction_category_id,
	txn_category_attribute_id,
	context_business_group_id,
	datetrack_mode,
	context         ,
        action_date ,
        src_effective_date,
	number_of_copies,
	display_name,
	replacement_type_cd,
	start_with,
	increment_by,
	status,
	object_version_number
    from	pqh_copy_entity_txns
    where	copy_entity_txn_id = p_copy_entity_txn_id;

Line: 150

    select 	copy_entity_txn_id,
	transaction_category_id,
	txn_category_attribute_id,
	context_business_group_id,
	datetrack_mode,
	context         ,
        action_date ,
        src_effective_date,
	number_of_copies ,
	display_name,
	replacement_type_cd,
	start_with,
	increment_by,
	status,
	object_version_number
    from	pqh_copy_entity_txns
    where	copy_entity_txn_id = p_copy_entity_txn_id
    for	update nowait;