APPS.PQH_RHT_SHD SQL Statements

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

Line: 84

    select
		routing_history_id,
	approval_cd,
	comments,
	forwarded_by_assignment_id,
	forwarded_by_member_id,
	forwarded_by_position_id,
	forwarded_by_user_id,
	forwarded_by_role_id,
	forwarded_to_assignment_id,
	forwarded_to_member_id,
	forwarded_to_position_id,
	forwarded_to_user_id,
	forwarded_to_role_id,
	notification_date,
	pos_structure_version_id,
	routing_category_id,
	transaction_category_id,
	transaction_id,
	user_action_cd,
        from_range_name,
        to_range_name,
        list_range_name,
	object_version_number
    from	pqh_routing_history
    where	routing_history_id = p_routing_history_id;

Line: 177

    select 	routing_history_id,
	approval_cd,
	comments,
	forwarded_by_assignment_id,
	forwarded_by_member_id,
	forwarded_by_position_id,
	forwarded_by_user_id,
	forwarded_by_role_id,
	forwarded_to_assignment_id,
	forwarded_to_member_id,
	forwarded_to_position_id,
	forwarded_to_user_id,
	forwarded_to_role_id,
	notification_date,
	pos_structure_version_id,
	routing_category_id,
	transaction_category_id,
	transaction_id,
	user_action_cd,
        from_range_name,
        to_range_name,
        list_range_name,
	object_version_number
    from	pqh_routing_history
    where	routing_history_id = p_routing_history_id
    for	update nowait;